package com.demo.domain;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class FctOtsorderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public FctOtsorderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andSerialnumberIsNull() {
            addCriterion("SerialNumber is null");
            return (Criteria) this;
        }

        public Criteria andSerialnumberIsNotNull() {
            addCriterion("SerialNumber is not null");
            return (Criteria) this;
        }

        public Criteria andSerialnumberEqualTo(Integer value) {
            addCriterion("SerialNumber =", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberNotEqualTo(Integer value) {
            addCriterion("SerialNumber <>", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberGreaterThan(Integer value) {
            addCriterion("SerialNumber >", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("SerialNumber >=", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberLessThan(Integer value) {
            addCriterion("SerialNumber <", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberLessThanOrEqualTo(Integer value) {
            addCriterion("SerialNumber <=", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberIn(List<Integer> values) {
            addCriterion("SerialNumber in", values, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberNotIn(List<Integer> values) {
            addCriterion("SerialNumber not in", values, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberBetween(Integer value1, Integer value2) {
            addCriterion("SerialNumber between", value1, value2, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberNotBetween(Integer value1, Integer value2) {
            addCriterion("SerialNumber not between", value1, value2, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andOtsordercodeIsNull() {
            addCriterion("OTSOrderCode is null");
            return (Criteria) this;
        }

        public Criteria andOtsordercodeIsNotNull() {
            addCriterion("OTSOrderCode is not null");
            return (Criteria) this;
        }

        public Criteria andOtsordercodeEqualTo(String value) {
            addCriterion("OTSOrderCode =", value, "otsordercode");
            return (Criteria) this;
        }

        public Criteria andOtsordercodeNotEqualTo(String value) {
            addCriterion("OTSOrderCode <>", value, "otsordercode");
            return (Criteria) this;
        }

        public Criteria andOtsordercodeGreaterThan(String value) {
            addCriterion("OTSOrderCode >", value, "otsordercode");
            return (Criteria) this;
        }

        public Criteria andOtsordercodeGreaterThanOrEqualTo(String value) {
            addCriterion("OTSOrderCode >=", value, "otsordercode");
            return (Criteria) this;
        }

        public Criteria andOtsordercodeLessThan(String value) {
            addCriterion("OTSOrderCode <", value, "otsordercode");
            return (Criteria) this;
        }

        public Criteria andOtsordercodeLessThanOrEqualTo(String value) {
            addCriterion("OTSOrderCode <=", value, "otsordercode");
            return (Criteria) this;
        }

        public Criteria andOtsordercodeLike(String value) {
            addCriterion("OTSOrderCode like", value, "otsordercode");
            return (Criteria) this;
        }

        public Criteria andOtsordercodeNotLike(String value) {
            addCriterion("OTSOrderCode not like", value, "otsordercode");
            return (Criteria) this;
        }

        public Criteria andOtsordercodeIn(List<String> values) {
            addCriterion("OTSOrderCode in", values, "otsordercode");
            return (Criteria) this;
        }

        public Criteria andOtsordercodeNotIn(List<String> values) {
            addCriterion("OTSOrderCode not in", values, "otsordercode");
            return (Criteria) this;
        }

        public Criteria andOtsordercodeBetween(String value1, String value2) {
            addCriterion("OTSOrderCode between", value1, value2, "otsordercode");
            return (Criteria) this;
        }

        public Criteria andOtsordercodeNotBetween(String value1, String value2) {
            addCriterion("OTSOrderCode not between", value1, value2, "otsordercode");
            return (Criteria) this;
        }

        public Criteria andOtsordertypeIsNull() {
            addCriterion("OTSOrderType is null");
            return (Criteria) this;
        }

        public Criteria andOtsordertypeIsNotNull() {
            addCriterion("OTSOrderType is not null");
            return (Criteria) this;
        }

        public Criteria andOtsordertypeEqualTo(Integer value) {
            addCriterion("OTSOrderType =", value, "otsordertype");
            return (Criteria) this;
        }

        public Criteria andOtsordertypeNotEqualTo(Integer value) {
            addCriterion("OTSOrderType <>", value, "otsordertype");
            return (Criteria) this;
        }

        public Criteria andOtsordertypeGreaterThan(Integer value) {
            addCriterion("OTSOrderType >", value, "otsordertype");
            return (Criteria) this;
        }

        public Criteria andOtsordertypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("OTSOrderType >=", value, "otsordertype");
            return (Criteria) this;
        }

        public Criteria andOtsordertypeLessThan(Integer value) {
            addCriterion("OTSOrderType <", value, "otsordertype");
            return (Criteria) this;
        }

        public Criteria andOtsordertypeLessThanOrEqualTo(Integer value) {
            addCriterion("OTSOrderType <=", value, "otsordertype");
            return (Criteria) this;
        }

        public Criteria andOtsordertypeIn(List<Integer> values) {
            addCriterion("OTSOrderType in", values, "otsordertype");
            return (Criteria) this;
        }

        public Criteria andOtsordertypeNotIn(List<Integer> values) {
            addCriterion("OTSOrderType not in", values, "otsordertype");
            return (Criteria) this;
        }

        public Criteria andOtsordertypeBetween(Integer value1, Integer value2) {
            addCriterion("OTSOrderType between", value1, value2, "otsordertype");
            return (Criteria) this;
        }

        public Criteria andOtsordertypeNotBetween(Integer value1, Integer value2) {
            addCriterion("OTSOrderType not between", value1, value2, "otsordertype");
            return (Criteria) this;
        }

        public Criteria andAreacodeIsNull() {
            addCriterion("AreaCode is null");
            return (Criteria) this;
        }

        public Criteria andAreacodeIsNotNull() {
            addCriterion("AreaCode is not null");
            return (Criteria) this;
        }

        public Criteria andAreacodeEqualTo(Integer value) {
            addCriterion("AreaCode =", value, "areacode");
            return (Criteria) this;
        }

        public Criteria andAreacodeNotEqualTo(Integer value) {
            addCriterion("AreaCode <>", value, "areacode");
            return (Criteria) this;
        }

        public Criteria andAreacodeGreaterThan(Integer value) {
            addCriterion("AreaCode >", value, "areacode");
            return (Criteria) this;
        }

        public Criteria andAreacodeGreaterThanOrEqualTo(Integer value) {
            addCriterion("AreaCode >=", value, "areacode");
            return (Criteria) this;
        }

        public Criteria andAreacodeLessThan(Integer value) {
            addCriterion("AreaCode <", value, "areacode");
            return (Criteria) this;
        }

        public Criteria andAreacodeLessThanOrEqualTo(Integer value) {
            addCriterion("AreaCode <=", value, "areacode");
            return (Criteria) this;
        }

        public Criteria andAreacodeIn(List<Integer> values) {
            addCriterion("AreaCode in", values, "areacode");
            return (Criteria) this;
        }

        public Criteria andAreacodeNotIn(List<Integer> values) {
            addCriterion("AreaCode not in", values, "areacode");
            return (Criteria) this;
        }

        public Criteria andAreacodeBetween(Integer value1, Integer value2) {
            addCriterion("AreaCode between", value1, value2, "areacode");
            return (Criteria) this;
        }

        public Criteria andAreacodeNotBetween(Integer value1, Integer value2) {
            addCriterion("AreaCode not between", value1, value2, "areacode");
            return (Criteria) this;
        }

        public Criteria andDeliverydateIsNull() {
            addCriterion("DeliveryDate is null");
            return (Criteria) this;
        }

        public Criteria andDeliverydateIsNotNull() {
            addCriterion("DeliveryDate is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverydateEqualTo(Date value) {
            addCriterion("DeliveryDate =", value, "deliverydate");
            return (Criteria) this;
        }

        public Criteria andDeliverydateNotEqualTo(Date value) {
            addCriterion("DeliveryDate <>", value, "deliverydate");
            return (Criteria) this;
        }

        public Criteria andDeliverydateGreaterThan(Date value) {
            addCriterion("DeliveryDate >", value, "deliverydate");
            return (Criteria) this;
        }

        public Criteria andDeliverydateGreaterThanOrEqualTo(Date value) {
            addCriterion("DeliveryDate >=", value, "deliverydate");
            return (Criteria) this;
        }

        public Criteria andDeliverydateLessThan(Date value) {
            addCriterion("DeliveryDate <", value, "deliverydate");
            return (Criteria) this;
        }

        public Criteria andDeliverydateLessThanOrEqualTo(Date value) {
            addCriterion("DeliveryDate <=", value, "deliverydate");
            return (Criteria) this;
        }

        public Criteria andDeliverydateIn(List<Date> values) {
            addCriterion("DeliveryDate in", values, "deliverydate");
            return (Criteria) this;
        }

        public Criteria andDeliverydateNotIn(List<Date> values) {
            addCriterion("DeliveryDate not in", values, "deliverydate");
            return (Criteria) this;
        }

        public Criteria andDeliverydateBetween(Date value1, Date value2) {
            addCriterion("DeliveryDate between", value1, value2, "deliverydate");
            return (Criteria) this;
        }

        public Criteria andDeliverydateNotBetween(Date value1, Date value2) {
            addCriterion("DeliveryDate not between", value1, value2, "deliverydate");
            return (Criteria) this;
        }

        public Criteria andOutordercodeIsNull() {
            addCriterion("OutOrderCode is null");
            return (Criteria) this;
        }

        public Criteria andOutordercodeIsNotNull() {
            addCriterion("OutOrderCode is not null");
            return (Criteria) this;
        }

        public Criteria andOutordercodeEqualTo(String value) {
            addCriterion("OutOrderCode =", value, "outordercode");
            return (Criteria) this;
        }

        public Criteria andOutordercodeNotEqualTo(String value) {
            addCriterion("OutOrderCode <>", value, "outordercode");
            return (Criteria) this;
        }

        public Criteria andOutordercodeGreaterThan(String value) {
            addCriterion("OutOrderCode >", value, "outordercode");
            return (Criteria) this;
        }

        public Criteria andOutordercodeGreaterThanOrEqualTo(String value) {
            addCriterion("OutOrderCode >=", value, "outordercode");
            return (Criteria) this;
        }

        public Criteria andOutordercodeLessThan(String value) {
            addCriterion("OutOrderCode <", value, "outordercode");
            return (Criteria) this;
        }

        public Criteria andOutordercodeLessThanOrEqualTo(String value) {
            addCriterion("OutOrderCode <=", value, "outordercode");
            return (Criteria) this;
        }

        public Criteria andOutordercodeLike(String value) {
            addCriterion("OutOrderCode like", value, "outordercode");
            return (Criteria) this;
        }

        public Criteria andOutordercodeNotLike(String value) {
            addCriterion("OutOrderCode not like", value, "outordercode");
            return (Criteria) this;
        }

        public Criteria andOutordercodeIn(List<String> values) {
            addCriterion("OutOrderCode in", values, "outordercode");
            return (Criteria) this;
        }

        public Criteria andOutordercodeNotIn(List<String> values) {
            addCriterion("OutOrderCode not in", values, "outordercode");
            return (Criteria) this;
        }

        public Criteria andOutordercodeBetween(String value1, String value2) {
            addCriterion("OutOrderCode between", value1, value2, "outordercode");
            return (Criteria) this;
        }

        public Criteria andOutordercodeNotBetween(String value1, String value2) {
            addCriterion("OutOrderCode not between", value1, value2, "outordercode");
            return (Criteria) this;
        }

        public Criteria andSenderIsNull() {
            addCriterion("Sender is null");
            return (Criteria) this;
        }

        public Criteria andSenderIsNotNull() {
            addCriterion("Sender is not null");
            return (Criteria) this;
        }

        public Criteria andSenderEqualTo(String value) {
            addCriterion("Sender =", value, "sender");
            return (Criteria) this;
        }

        public Criteria andSenderNotEqualTo(String value) {
            addCriterion("Sender <>", value, "sender");
            return (Criteria) this;
        }

        public Criteria andSenderGreaterThan(String value) {
            addCriterion("Sender >", value, "sender");
            return (Criteria) this;
        }

        public Criteria andSenderGreaterThanOrEqualTo(String value) {
            addCriterion("Sender >=", value, "sender");
            return (Criteria) this;
        }

        public Criteria andSenderLessThan(String value) {
            addCriterion("Sender <", value, "sender");
            return (Criteria) this;
        }

        public Criteria andSenderLessThanOrEqualTo(String value) {
            addCriterion("Sender <=", value, "sender");
            return (Criteria) this;
        }

        public Criteria andSenderLike(String value) {
            addCriterion("Sender like", value, "sender");
            return (Criteria) this;
        }

        public Criteria andSenderNotLike(String value) {
            addCriterion("Sender not like", value, "sender");
            return (Criteria) this;
        }

        public Criteria andSenderIn(List<String> values) {
            addCriterion("Sender in", values, "sender");
            return (Criteria) this;
        }

        public Criteria andSenderNotIn(List<String> values) {
            addCriterion("Sender not in", values, "sender");
            return (Criteria) this;
        }

        public Criteria andSenderBetween(String value1, String value2) {
            addCriterion("Sender between", value1, value2, "sender");
            return (Criteria) this;
        }

        public Criteria andSenderNotBetween(String value1, String value2) {
            addCriterion("Sender not between", value1, value2, "sender");
            return (Criteria) this;
        }

        public Criteria andSendertelIsNull() {
            addCriterion("SenderTel is null");
            return (Criteria) this;
        }

        public Criteria andSendertelIsNotNull() {
            addCriterion("SenderTel is not null");
            return (Criteria) this;
        }

        public Criteria andSendertelEqualTo(String value) {
            addCriterion("SenderTel =", value, "sendertel");
            return (Criteria) this;
        }

        public Criteria andSendertelNotEqualTo(String value) {
            addCriterion("SenderTel <>", value, "sendertel");
            return (Criteria) this;
        }

        public Criteria andSendertelGreaterThan(String value) {
            addCriterion("SenderTel >", value, "sendertel");
            return (Criteria) this;
        }

        public Criteria andSendertelGreaterThanOrEqualTo(String value) {
            addCriterion("SenderTel >=", value, "sendertel");
            return (Criteria) this;
        }

        public Criteria andSendertelLessThan(String value) {
            addCriterion("SenderTel <", value, "sendertel");
            return (Criteria) this;
        }

        public Criteria andSendertelLessThanOrEqualTo(String value) {
            addCriterion("SenderTel <=", value, "sendertel");
            return (Criteria) this;
        }

        public Criteria andSendertelLike(String value) {
            addCriterion("SenderTel like", value, "sendertel");
            return (Criteria) this;
        }

        public Criteria andSendertelNotLike(String value) {
            addCriterion("SenderTel not like", value, "sendertel");
            return (Criteria) this;
        }

        public Criteria andSendertelIn(List<String> values) {
            addCriterion("SenderTel in", values, "sendertel");
            return (Criteria) this;
        }

        public Criteria andSendertelNotIn(List<String> values) {
            addCriterion("SenderTel not in", values, "sendertel");
            return (Criteria) this;
        }

        public Criteria andSendertelBetween(String value1, String value2) {
            addCriterion("SenderTel between", value1, value2, "sendertel");
            return (Criteria) this;
        }

        public Criteria andSendertelNotBetween(String value1, String value2) {
            addCriterion("SenderTel not between", value1, value2, "sendertel");
            return (Criteria) this;
        }

        public Criteria andSendermobileIsNull() {
            addCriterion("SenderMobile is null");
            return (Criteria) this;
        }

        public Criteria andSendermobileIsNotNull() {
            addCriterion("SenderMobile is not null");
            return (Criteria) this;
        }

        public Criteria andSendermobileEqualTo(String value) {
            addCriterion("SenderMobile =", value, "sendermobile");
            return (Criteria) this;
        }

        public Criteria andSendermobileNotEqualTo(String value) {
            addCriterion("SenderMobile <>", value, "sendermobile");
            return (Criteria) this;
        }

        public Criteria andSendermobileGreaterThan(String value) {
            addCriterion("SenderMobile >", value, "sendermobile");
            return (Criteria) this;
        }

        public Criteria andSendermobileGreaterThanOrEqualTo(String value) {
            addCriterion("SenderMobile >=", value, "sendermobile");
            return (Criteria) this;
        }

        public Criteria andSendermobileLessThan(String value) {
            addCriterion("SenderMobile <", value, "sendermobile");
            return (Criteria) this;
        }

        public Criteria andSendermobileLessThanOrEqualTo(String value) {
            addCriterion("SenderMobile <=", value, "sendermobile");
            return (Criteria) this;
        }

        public Criteria andSendermobileLike(String value) {
            addCriterion("SenderMobile like", value, "sendermobile");
            return (Criteria) this;
        }

        public Criteria andSendermobileNotLike(String value) {
            addCriterion("SenderMobile not like", value, "sendermobile");
            return (Criteria) this;
        }

        public Criteria andSendermobileIn(List<String> values) {
            addCriterion("SenderMobile in", values, "sendermobile");
            return (Criteria) this;
        }

        public Criteria andSendermobileNotIn(List<String> values) {
            addCriterion("SenderMobile not in", values, "sendermobile");
            return (Criteria) this;
        }

        public Criteria andSendermobileBetween(String value1, String value2) {
            addCriterion("SenderMobile between", value1, value2, "sendermobile");
            return (Criteria) this;
        }

        public Criteria andSendermobileNotBetween(String value1, String value2) {
            addCriterion("SenderMobile not between", value1, value2, "sendermobile");
            return (Criteria) this;
        }

        public Criteria andSenderprovinceIsNull() {
            addCriterion("SenderProvince is null");
            return (Criteria) this;
        }

        public Criteria andSenderprovinceIsNotNull() {
            addCriterion("SenderProvince is not null");
            return (Criteria) this;
        }

        public Criteria andSenderprovinceEqualTo(String value) {
            addCriterion("SenderProvince =", value, "senderprovince");
            return (Criteria) this;
        }

        public Criteria andSenderprovinceNotEqualTo(String value) {
            addCriterion("SenderProvince <>", value, "senderprovince");
            return (Criteria) this;
        }

        public Criteria andSenderprovinceGreaterThan(String value) {
            addCriterion("SenderProvince >", value, "senderprovince");
            return (Criteria) this;
        }

        public Criteria andSenderprovinceGreaterThanOrEqualTo(String value) {
            addCriterion("SenderProvince >=", value, "senderprovince");
            return (Criteria) this;
        }

        public Criteria andSenderprovinceLessThan(String value) {
            addCriterion("SenderProvince <", value, "senderprovince");
            return (Criteria) this;
        }

        public Criteria andSenderprovinceLessThanOrEqualTo(String value) {
            addCriterion("SenderProvince <=", value, "senderprovince");
            return (Criteria) this;
        }

        public Criteria andSenderprovinceLike(String value) {
            addCriterion("SenderProvince like", value, "senderprovince");
            return (Criteria) this;
        }

        public Criteria andSenderprovinceNotLike(String value) {
            addCriterion("SenderProvince not like", value, "senderprovince");
            return (Criteria) this;
        }

        public Criteria andSenderprovinceIn(List<String> values) {
            addCriterion("SenderProvince in", values, "senderprovince");
            return (Criteria) this;
        }

        public Criteria andSenderprovinceNotIn(List<String> values) {
            addCriterion("SenderProvince not in", values, "senderprovince");
            return (Criteria) this;
        }

        public Criteria andSenderprovinceBetween(String value1, String value2) {
            addCriterion("SenderProvince between", value1, value2, "senderprovince");
            return (Criteria) this;
        }

        public Criteria andSenderprovinceNotBetween(String value1, String value2) {
            addCriterion("SenderProvince not between", value1, value2, "senderprovince");
            return (Criteria) this;
        }

        public Criteria andSendercityIsNull() {
            addCriterion("SenderCity is null");
            return (Criteria) this;
        }

        public Criteria andSendercityIsNotNull() {
            addCriterion("SenderCity is not null");
            return (Criteria) this;
        }

        public Criteria andSendercityEqualTo(String value) {
            addCriterion("SenderCity =", value, "sendercity");
            return (Criteria) this;
        }

        public Criteria andSendercityNotEqualTo(String value) {
            addCriterion("SenderCity <>", value, "sendercity");
            return (Criteria) this;
        }

        public Criteria andSendercityGreaterThan(String value) {
            addCriterion("SenderCity >", value, "sendercity");
            return (Criteria) this;
        }

        public Criteria andSendercityGreaterThanOrEqualTo(String value) {
            addCriterion("SenderCity >=", value, "sendercity");
            return (Criteria) this;
        }

        public Criteria andSendercityLessThan(String value) {
            addCriterion("SenderCity <", value, "sendercity");
            return (Criteria) this;
        }

        public Criteria andSendercityLessThanOrEqualTo(String value) {
            addCriterion("SenderCity <=", value, "sendercity");
            return (Criteria) this;
        }

        public Criteria andSendercityLike(String value) {
            addCriterion("SenderCity like", value, "sendercity");
            return (Criteria) this;
        }

        public Criteria andSendercityNotLike(String value) {
            addCriterion("SenderCity not like", value, "sendercity");
            return (Criteria) this;
        }

        public Criteria andSendercityIn(List<String> values) {
            addCriterion("SenderCity in", values, "sendercity");
            return (Criteria) this;
        }

        public Criteria andSendercityNotIn(List<String> values) {
            addCriterion("SenderCity not in", values, "sendercity");
            return (Criteria) this;
        }

        public Criteria andSendercityBetween(String value1, String value2) {
            addCriterion("SenderCity between", value1, value2, "sendercity");
            return (Criteria) this;
        }

        public Criteria andSendercityNotBetween(String value1, String value2) {
            addCriterion("SenderCity not between", value1, value2, "sendercity");
            return (Criteria) this;
        }

        public Criteria andSenderdistrictIsNull() {
            addCriterion("SenderDistrict is null");
            return (Criteria) this;
        }

        public Criteria andSenderdistrictIsNotNull() {
            addCriterion("SenderDistrict is not null");
            return (Criteria) this;
        }

        public Criteria andSenderdistrictEqualTo(String value) {
            addCriterion("SenderDistrict =", value, "senderdistrict");
            return (Criteria) this;
        }

        public Criteria andSenderdistrictNotEqualTo(String value) {
            addCriterion("SenderDistrict <>", value, "senderdistrict");
            return (Criteria) this;
        }

        public Criteria andSenderdistrictGreaterThan(String value) {
            addCriterion("SenderDistrict >", value, "senderdistrict");
            return (Criteria) this;
        }

        public Criteria andSenderdistrictGreaterThanOrEqualTo(String value) {
            addCriterion("SenderDistrict >=", value, "senderdistrict");
            return (Criteria) this;
        }

        public Criteria andSenderdistrictLessThan(String value) {
            addCriterion("SenderDistrict <", value, "senderdistrict");
            return (Criteria) this;
        }

        public Criteria andSenderdistrictLessThanOrEqualTo(String value) {
            addCriterion("SenderDistrict <=", value, "senderdistrict");
            return (Criteria) this;
        }

        public Criteria andSenderdistrictLike(String value) {
            addCriterion("SenderDistrict like", value, "senderdistrict");
            return (Criteria) this;
        }

        public Criteria andSenderdistrictNotLike(String value) {
            addCriterion("SenderDistrict not like", value, "senderdistrict");
            return (Criteria) this;
        }

        public Criteria andSenderdistrictIn(List<String> values) {
            addCriterion("SenderDistrict in", values, "senderdistrict");
            return (Criteria) this;
        }

        public Criteria andSenderdistrictNotIn(List<String> values) {
            addCriterion("SenderDistrict not in", values, "senderdistrict");
            return (Criteria) this;
        }

        public Criteria andSenderdistrictBetween(String value1, String value2) {
            addCriterion("SenderDistrict between", value1, value2, "senderdistrict");
            return (Criteria) this;
        }

        public Criteria andSenderdistrictNotBetween(String value1, String value2) {
            addCriterion("SenderDistrict not between", value1, value2, "senderdistrict");
            return (Criteria) this;
        }

        public Criteria andSenderaddressIsNull() {
            addCriterion("SenderAddress is null");
            return (Criteria) this;
        }

        public Criteria andSenderaddressIsNotNull() {
            addCriterion("SenderAddress is not null");
            return (Criteria) this;
        }

        public Criteria andSenderaddressEqualTo(String value) {
            addCriterion("SenderAddress =", value, "senderaddress");
            return (Criteria) this;
        }

        public Criteria andSenderaddressNotEqualTo(String value) {
            addCriterion("SenderAddress <>", value, "senderaddress");
            return (Criteria) this;
        }

        public Criteria andSenderaddressGreaterThan(String value) {
            addCriterion("SenderAddress >", value, "senderaddress");
            return (Criteria) this;
        }

        public Criteria andSenderaddressGreaterThanOrEqualTo(String value) {
            addCriterion("SenderAddress >=", value, "senderaddress");
            return (Criteria) this;
        }

        public Criteria andSenderaddressLessThan(String value) {
            addCriterion("SenderAddress <", value, "senderaddress");
            return (Criteria) this;
        }

        public Criteria andSenderaddressLessThanOrEqualTo(String value) {
            addCriterion("SenderAddress <=", value, "senderaddress");
            return (Criteria) this;
        }

        public Criteria andSenderaddressLike(String value) {
            addCriterion("SenderAddress like", value, "senderaddress");
            return (Criteria) this;
        }

        public Criteria andSenderaddressNotLike(String value) {
            addCriterion("SenderAddress not like", value, "senderaddress");
            return (Criteria) this;
        }

        public Criteria andSenderaddressIn(List<String> values) {
            addCriterion("SenderAddress in", values, "senderaddress");
            return (Criteria) this;
        }

        public Criteria andSenderaddressNotIn(List<String> values) {
            addCriterion("SenderAddress not in", values, "senderaddress");
            return (Criteria) this;
        }

        public Criteria andSenderaddressBetween(String value1, String value2) {
            addCriterion("SenderAddress between", value1, value2, "senderaddress");
            return (Criteria) this;
        }

        public Criteria andSenderaddressNotBetween(String value1, String value2) {
            addCriterion("SenderAddress not between", value1, value2, "senderaddress");
            return (Criteria) this;
        }

        public Criteria andReceiverIsNull() {
            addCriterion("Receiver is null");
            return (Criteria) this;
        }

        public Criteria andReceiverIsNotNull() {
            addCriterion("Receiver is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverEqualTo(String value) {
            addCriterion("Receiver =", value, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverNotEqualTo(String value) {
            addCriterion("Receiver <>", value, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverGreaterThan(String value) {
            addCriterion("Receiver >", value, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverGreaterThanOrEqualTo(String value) {
            addCriterion("Receiver >=", value, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverLessThan(String value) {
            addCriterion("Receiver <", value, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverLessThanOrEqualTo(String value) {
            addCriterion("Receiver <=", value, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverLike(String value) {
            addCriterion("Receiver like", value, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverNotLike(String value) {
            addCriterion("Receiver not like", value, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverIn(List<String> values) {
            addCriterion("Receiver in", values, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverNotIn(List<String> values) {
            addCriterion("Receiver not in", values, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverBetween(String value1, String value2) {
            addCriterion("Receiver between", value1, value2, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverNotBetween(String value1, String value2) {
            addCriterion("Receiver not between", value1, value2, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceivertelIsNull() {
            addCriterion("ReceiverTel is null");
            return (Criteria) this;
        }

        public Criteria andReceivertelIsNotNull() {
            addCriterion("ReceiverTel is not null");
            return (Criteria) this;
        }

        public Criteria andReceivertelEqualTo(String value) {
            addCriterion("ReceiverTel =", value, "receivertel");
            return (Criteria) this;
        }

        public Criteria andReceivertelNotEqualTo(String value) {
            addCriterion("ReceiverTel <>", value, "receivertel");
            return (Criteria) this;
        }

        public Criteria andReceivertelGreaterThan(String value) {
            addCriterion("ReceiverTel >", value, "receivertel");
            return (Criteria) this;
        }

        public Criteria andReceivertelGreaterThanOrEqualTo(String value) {
            addCriterion("ReceiverTel >=", value, "receivertel");
            return (Criteria) this;
        }

        public Criteria andReceivertelLessThan(String value) {
            addCriterion("ReceiverTel <", value, "receivertel");
            return (Criteria) this;
        }

        public Criteria andReceivertelLessThanOrEqualTo(String value) {
            addCriterion("ReceiverTel <=", value, "receivertel");
            return (Criteria) this;
        }

        public Criteria andReceivertelLike(String value) {
            addCriterion("ReceiverTel like", value, "receivertel");
            return (Criteria) this;
        }

        public Criteria andReceivertelNotLike(String value) {
            addCriterion("ReceiverTel not like", value, "receivertel");
            return (Criteria) this;
        }

        public Criteria andReceivertelIn(List<String> values) {
            addCriterion("ReceiverTel in", values, "receivertel");
            return (Criteria) this;
        }

        public Criteria andReceivertelNotIn(List<String> values) {
            addCriterion("ReceiverTel not in", values, "receivertel");
            return (Criteria) this;
        }

        public Criteria andReceivertelBetween(String value1, String value2) {
            addCriterion("ReceiverTel between", value1, value2, "receivertel");
            return (Criteria) this;
        }

        public Criteria andReceivertelNotBetween(String value1, String value2) {
            addCriterion("ReceiverTel not between", value1, value2, "receivertel");
            return (Criteria) this;
        }

        public Criteria andReceivermobileIsNull() {
            addCriterion("ReceiverMobile is null");
            return (Criteria) this;
        }

        public Criteria andReceivermobileIsNotNull() {
            addCriterion("ReceiverMobile is not null");
            return (Criteria) this;
        }

        public Criteria andReceivermobileEqualTo(String value) {
            addCriterion("ReceiverMobile =", value, "receivermobile");
            return (Criteria) this;
        }

        public Criteria andReceivermobileNotEqualTo(String value) {
            addCriterion("ReceiverMobile <>", value, "receivermobile");
            return (Criteria) this;
        }

        public Criteria andReceivermobileGreaterThan(String value) {
            addCriterion("ReceiverMobile >", value, "receivermobile");
            return (Criteria) this;
        }

        public Criteria andReceivermobileGreaterThanOrEqualTo(String value) {
            addCriterion("ReceiverMobile >=", value, "receivermobile");
            return (Criteria) this;
        }

        public Criteria andReceivermobileLessThan(String value) {
            addCriterion("ReceiverMobile <", value, "receivermobile");
            return (Criteria) this;
        }

        public Criteria andReceivermobileLessThanOrEqualTo(String value) {
            addCriterion("ReceiverMobile <=", value, "receivermobile");
            return (Criteria) this;
        }

        public Criteria andReceivermobileLike(String value) {
            addCriterion("ReceiverMobile like", value, "receivermobile");
            return (Criteria) this;
        }

        public Criteria andReceivermobileNotLike(String value) {
            addCriterion("ReceiverMobile not like", value, "receivermobile");
            return (Criteria) this;
        }

        public Criteria andReceivermobileIn(List<String> values) {
            addCriterion("ReceiverMobile in", values, "receivermobile");
            return (Criteria) this;
        }

        public Criteria andReceivermobileNotIn(List<String> values) {
            addCriterion("ReceiverMobile not in", values, "receivermobile");
            return (Criteria) this;
        }

        public Criteria andReceivermobileBetween(String value1, String value2) {
            addCriterion("ReceiverMobile between", value1, value2, "receivermobile");
            return (Criteria) this;
        }

        public Criteria andReceivermobileNotBetween(String value1, String value2) {
            addCriterion("ReceiverMobile not between", value1, value2, "receivermobile");
            return (Criteria) this;
        }

        public Criteria andReceiverprovinceIsNull() {
            addCriterion("ReceiverProvince is null");
            return (Criteria) this;
        }

        public Criteria andReceiverprovinceIsNotNull() {
            addCriterion("ReceiverProvince is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverprovinceEqualTo(String value) {
            addCriterion("ReceiverProvince =", value, "receiverprovince");
            return (Criteria) this;
        }

        public Criteria andReceiverprovinceNotEqualTo(String value) {
            addCriterion("ReceiverProvince <>", value, "receiverprovince");
            return (Criteria) this;
        }

        public Criteria andReceiverprovinceGreaterThan(String value) {
            addCriterion("ReceiverProvince >", value, "receiverprovince");
            return (Criteria) this;
        }

        public Criteria andReceiverprovinceGreaterThanOrEqualTo(String value) {
            addCriterion("ReceiverProvince >=", value, "receiverprovince");
            return (Criteria) this;
        }

        public Criteria andReceiverprovinceLessThan(String value) {
            addCriterion("ReceiverProvince <", value, "receiverprovince");
            return (Criteria) this;
        }

        public Criteria andReceiverprovinceLessThanOrEqualTo(String value) {
            addCriterion("ReceiverProvince <=", value, "receiverprovince");
            return (Criteria) this;
        }

        public Criteria andReceiverprovinceLike(String value) {
            addCriterion("ReceiverProvince like", value, "receiverprovince");
            return (Criteria) this;
        }

        public Criteria andReceiverprovinceNotLike(String value) {
            addCriterion("ReceiverProvince not like", value, "receiverprovince");
            return (Criteria) this;
        }

        public Criteria andReceiverprovinceIn(List<String> values) {
            addCriterion("ReceiverProvince in", values, "receiverprovince");
            return (Criteria) this;
        }

        public Criteria andReceiverprovinceNotIn(List<String> values) {
            addCriterion("ReceiverProvince not in", values, "receiverprovince");
            return (Criteria) this;
        }

        public Criteria andReceiverprovinceBetween(String value1, String value2) {
            addCriterion("ReceiverProvince between", value1, value2, "receiverprovince");
            return (Criteria) this;
        }

        public Criteria andReceiverprovinceNotBetween(String value1, String value2) {
            addCriterion("ReceiverProvince not between", value1, value2, "receiverprovince");
            return (Criteria) this;
        }

        public Criteria andReceivercityIsNull() {
            addCriterion("ReceiverCity is null");
            return (Criteria) this;
        }

        public Criteria andReceivercityIsNotNull() {
            addCriterion("ReceiverCity is not null");
            return (Criteria) this;
        }

        public Criteria andReceivercityEqualTo(String value) {
            addCriterion("ReceiverCity =", value, "receivercity");
            return (Criteria) this;
        }

        public Criteria andReceivercityNotEqualTo(String value) {
            addCriterion("ReceiverCity <>", value, "receivercity");
            return (Criteria) this;
        }

        public Criteria andReceivercityGreaterThan(String value) {
            addCriterion("ReceiverCity >", value, "receivercity");
            return (Criteria) this;
        }

        public Criteria andReceivercityGreaterThanOrEqualTo(String value) {
            addCriterion("ReceiverCity >=", value, "receivercity");
            return (Criteria) this;
        }

        public Criteria andReceivercityLessThan(String value) {
            addCriterion("ReceiverCity <", value, "receivercity");
            return (Criteria) this;
        }

        public Criteria andReceivercityLessThanOrEqualTo(String value) {
            addCriterion("ReceiverCity <=", value, "receivercity");
            return (Criteria) this;
        }

        public Criteria andReceivercityLike(String value) {
            addCriterion("ReceiverCity like", value, "receivercity");
            return (Criteria) this;
        }

        public Criteria andReceivercityNotLike(String value) {
            addCriterion("ReceiverCity not like", value, "receivercity");
            return (Criteria) this;
        }

        public Criteria andReceivercityIn(List<String> values) {
            addCriterion("ReceiverCity in", values, "receivercity");
            return (Criteria) this;
        }

        public Criteria andReceivercityNotIn(List<String> values) {
            addCriterion("ReceiverCity not in", values, "receivercity");
            return (Criteria) this;
        }

        public Criteria andReceivercityBetween(String value1, String value2) {
            addCriterion("ReceiverCity between", value1, value2, "receivercity");
            return (Criteria) this;
        }

        public Criteria andReceivercityNotBetween(String value1, String value2) {
            addCriterion("ReceiverCity not between", value1, value2, "receivercity");
            return (Criteria) this;
        }

        public Criteria andReceiverdistrictIsNull() {
            addCriterion("ReceiverDistrict is null");
            return (Criteria) this;
        }

        public Criteria andReceiverdistrictIsNotNull() {
            addCriterion("ReceiverDistrict is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverdistrictEqualTo(String value) {
            addCriterion("ReceiverDistrict =", value, "receiverdistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverdistrictNotEqualTo(String value) {
            addCriterion("ReceiverDistrict <>", value, "receiverdistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverdistrictGreaterThan(String value) {
            addCriterion("ReceiverDistrict >", value, "receiverdistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverdistrictGreaterThanOrEqualTo(String value) {
            addCriterion("ReceiverDistrict >=", value, "receiverdistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverdistrictLessThan(String value) {
            addCriterion("ReceiverDistrict <", value, "receiverdistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverdistrictLessThanOrEqualTo(String value) {
            addCriterion("ReceiverDistrict <=", value, "receiverdistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverdistrictLike(String value) {
            addCriterion("ReceiverDistrict like", value, "receiverdistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverdistrictNotLike(String value) {
            addCriterion("ReceiverDistrict not like", value, "receiverdistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverdistrictIn(List<String> values) {
            addCriterion("ReceiverDistrict in", values, "receiverdistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverdistrictNotIn(List<String> values) {
            addCriterion("ReceiverDistrict not in", values, "receiverdistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverdistrictBetween(String value1, String value2) {
            addCriterion("ReceiverDistrict between", value1, value2, "receiverdistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverdistrictNotBetween(String value1, String value2) {
            addCriterion("ReceiverDistrict not between", value1, value2, "receiverdistrict");
            return (Criteria) this;
        }

        public Criteria andReceiveraddressIsNull() {
            addCriterion("ReceiverAddress is null");
            return (Criteria) this;
        }

        public Criteria andReceiveraddressIsNotNull() {
            addCriterion("ReceiverAddress is not null");
            return (Criteria) this;
        }

        public Criteria andReceiveraddressEqualTo(String value) {
            addCriterion("ReceiverAddress =", value, "receiveraddress");
            return (Criteria) this;
        }

        public Criteria andReceiveraddressNotEqualTo(String value) {
            addCriterion("ReceiverAddress <>", value, "receiveraddress");
            return (Criteria) this;
        }

        public Criteria andReceiveraddressGreaterThan(String value) {
            addCriterion("ReceiverAddress >", value, "receiveraddress");
            return (Criteria) this;
        }

        public Criteria andReceiveraddressGreaterThanOrEqualTo(String value) {
            addCriterion("ReceiverAddress >=", value, "receiveraddress");
            return (Criteria) this;
        }

        public Criteria andReceiveraddressLessThan(String value) {
            addCriterion("ReceiverAddress <", value, "receiveraddress");
            return (Criteria) this;
        }

        public Criteria andReceiveraddressLessThanOrEqualTo(String value) {
            addCriterion("ReceiverAddress <=", value, "receiveraddress");
            return (Criteria) this;
        }

        public Criteria andReceiveraddressLike(String value) {
            addCriterion("ReceiverAddress like", value, "receiveraddress");
            return (Criteria) this;
        }

        public Criteria andReceiveraddressNotLike(String value) {
            addCriterion("ReceiverAddress not like", value, "receiveraddress");
            return (Criteria) this;
        }

        public Criteria andReceiveraddressIn(List<String> values) {
            addCriterion("ReceiverAddress in", values, "receiveraddress");
            return (Criteria) this;
        }

        public Criteria andReceiveraddressNotIn(List<String> values) {
            addCriterion("ReceiverAddress not in", values, "receiveraddress");
            return (Criteria) this;
        }

        public Criteria andReceiveraddressBetween(String value1, String value2) {
            addCriterion("ReceiverAddress between", value1, value2, "receiveraddress");
            return (Criteria) this;
        }

        public Criteria andReceiveraddressNotBetween(String value1, String value2) {
            addCriterion("ReceiverAddress not between", value1, value2, "receiveraddress");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNull() {
            addCriterion("PostCode is null");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNotNull() {
            addCriterion("PostCode is not null");
            return (Criteria) this;
        }

        public Criteria andPostcodeEqualTo(String value) {
            addCriterion("PostCode =", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotEqualTo(String value) {
            addCriterion("PostCode <>", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThan(String value) {
            addCriterion("PostCode >", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThanOrEqualTo(String value) {
            addCriterion("PostCode >=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThan(String value) {
            addCriterion("PostCode <", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThanOrEqualTo(String value) {
            addCriterion("PostCode <=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLike(String value) {
            addCriterion("PostCode like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotLike(String value) {
            addCriterion("PostCode not like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeIn(List<String> values) {
            addCriterion("PostCode in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotIn(List<String> values) {
            addCriterion("PostCode not in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeBetween(String value1, String value2) {
            addCriterion("PostCode between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotBetween(String value1, String value2) {
            addCriterion("PostCode not between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andDrivernameIsNull() {
            addCriterion("DriverName is null");
            return (Criteria) this;
        }

        public Criteria andDrivernameIsNotNull() {
            addCriterion("DriverName is not null");
            return (Criteria) this;
        }

        public Criteria andDrivernameEqualTo(String value) {
            addCriterion("DriverName =", value, "drivername");
            return (Criteria) this;
        }

        public Criteria andDrivernameNotEqualTo(String value) {
            addCriterion("DriverName <>", value, "drivername");
            return (Criteria) this;
        }

        public Criteria andDrivernameGreaterThan(String value) {
            addCriterion("DriverName >", value, "drivername");
            return (Criteria) this;
        }

        public Criteria andDrivernameGreaterThanOrEqualTo(String value) {
            addCriterion("DriverName >=", value, "drivername");
            return (Criteria) this;
        }

        public Criteria andDrivernameLessThan(String value) {
            addCriterion("DriverName <", value, "drivername");
            return (Criteria) this;
        }

        public Criteria andDrivernameLessThanOrEqualTo(String value) {
            addCriterion("DriverName <=", value, "drivername");
            return (Criteria) this;
        }

        public Criteria andDrivernameLike(String value) {
            addCriterion("DriverName like", value, "drivername");
            return (Criteria) this;
        }

        public Criteria andDrivernameNotLike(String value) {
            addCriterion("DriverName not like", value, "drivername");
            return (Criteria) this;
        }

        public Criteria andDrivernameIn(List<String> values) {
            addCriterion("DriverName in", values, "drivername");
            return (Criteria) this;
        }

        public Criteria andDrivernameNotIn(List<String> values) {
            addCriterion("DriverName not in", values, "drivername");
            return (Criteria) this;
        }

        public Criteria andDrivernameBetween(String value1, String value2) {
            addCriterion("DriverName between", value1, value2, "drivername");
            return (Criteria) this;
        }

        public Criteria andDrivernameNotBetween(String value1, String value2) {
            addCriterion("DriverName not between", value1, value2, "drivername");
            return (Criteria) this;
        }

        public Criteria andDeliverynameIsNull() {
            addCriterion("DeliveryName is null");
            return (Criteria) this;
        }

        public Criteria andDeliverynameIsNotNull() {
            addCriterion("DeliveryName is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverynameEqualTo(String value) {
            addCriterion("DeliveryName =", value, "deliveryname");
            return (Criteria) this;
        }

        public Criteria andDeliverynameNotEqualTo(String value) {
            addCriterion("DeliveryName <>", value, "deliveryname");
            return (Criteria) this;
        }

        public Criteria andDeliverynameGreaterThan(String value) {
            addCriterion("DeliveryName >", value, "deliveryname");
            return (Criteria) this;
        }

        public Criteria andDeliverynameGreaterThanOrEqualTo(String value) {
            addCriterion("DeliveryName >=", value, "deliveryname");
            return (Criteria) this;
        }

        public Criteria andDeliverynameLessThan(String value) {
            addCriterion("DeliveryName <", value, "deliveryname");
            return (Criteria) this;
        }

        public Criteria andDeliverynameLessThanOrEqualTo(String value) {
            addCriterion("DeliveryName <=", value, "deliveryname");
            return (Criteria) this;
        }

        public Criteria andDeliverynameLike(String value) {
            addCriterion("DeliveryName like", value, "deliveryname");
            return (Criteria) this;
        }

        public Criteria andDeliverynameNotLike(String value) {
            addCriterion("DeliveryName not like", value, "deliveryname");
            return (Criteria) this;
        }

        public Criteria andDeliverynameIn(List<String> values) {
            addCriterion("DeliveryName in", values, "deliveryname");
            return (Criteria) this;
        }

        public Criteria andDeliverynameNotIn(List<String> values) {
            addCriterion("DeliveryName not in", values, "deliveryname");
            return (Criteria) this;
        }

        public Criteria andDeliverynameBetween(String value1, String value2) {
            addCriterion("DeliveryName between", value1, value2, "deliveryname");
            return (Criteria) this;
        }

        public Criteria andDeliverynameNotBetween(String value1, String value2) {
            addCriterion("DeliveryName not between", value1, value2, "deliveryname");
            return (Criteria) this;
        }

        public Criteria andIsinvoiceIsNull() {
            addCriterion("IsInvoice is null");
            return (Criteria) this;
        }

        public Criteria andIsinvoiceIsNotNull() {
            addCriterion("IsInvoice is not null");
            return (Criteria) this;
        }

        public Criteria andIsinvoiceEqualTo(Integer value) {
            addCriterion("IsInvoice =", value, "isinvoice");
            return (Criteria) this;
        }

        public Criteria andIsinvoiceNotEqualTo(Integer value) {
            addCriterion("IsInvoice <>", value, "isinvoice");
            return (Criteria) this;
        }

        public Criteria andIsinvoiceGreaterThan(Integer value) {
            addCriterion("IsInvoice >", value, "isinvoice");
            return (Criteria) this;
        }

        public Criteria andIsinvoiceGreaterThanOrEqualTo(Integer value) {
            addCriterion("IsInvoice >=", value, "isinvoice");
            return (Criteria) this;
        }

        public Criteria andIsinvoiceLessThan(Integer value) {
            addCriterion("IsInvoice <", value, "isinvoice");
            return (Criteria) this;
        }

        public Criteria andIsinvoiceLessThanOrEqualTo(Integer value) {
            addCriterion("IsInvoice <=", value, "isinvoice");
            return (Criteria) this;
        }

        public Criteria andIsinvoiceIn(List<Integer> values) {
            addCriterion("IsInvoice in", values, "isinvoice");
            return (Criteria) this;
        }

        public Criteria andIsinvoiceNotIn(List<Integer> values) {
            addCriterion("IsInvoice not in", values, "isinvoice");
            return (Criteria) this;
        }

        public Criteria andIsinvoiceBetween(Integer value1, Integer value2) {
            addCriterion("IsInvoice between", value1, value2, "isinvoice");
            return (Criteria) this;
        }

        public Criteria andIsinvoiceNotBetween(Integer value1, Integer value2) {
            addCriterion("IsInvoice not between", value1, value2, "isinvoice");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("Remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("Remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("Remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("Remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("Remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("Remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("Remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("Remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("Remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("Remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("Remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("Remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("Remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("Remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andOrderstateIsNull() {
            addCriterion("OrderState is null");
            return (Criteria) this;
        }

        public Criteria andOrderstateIsNotNull() {
            addCriterion("OrderState is not null");
            return (Criteria) this;
        }

        public Criteria andOrderstateEqualTo(Integer value) {
            addCriterion("OrderState =", value, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateNotEqualTo(Integer value) {
            addCriterion("OrderState <>", value, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateGreaterThan(Integer value) {
            addCriterion("OrderState >", value, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateGreaterThanOrEqualTo(Integer value) {
            addCriterion("OrderState >=", value, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateLessThan(Integer value) {
            addCriterion("OrderState <", value, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateLessThanOrEqualTo(Integer value) {
            addCriterion("OrderState <=", value, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateIn(List<Integer> values) {
            addCriterion("OrderState in", values, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateNotIn(List<Integer> values) {
            addCriterion("OrderState not in", values, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateBetween(Integer value1, Integer value2) {
            addCriterion("OrderState between", value1, value2, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateNotBetween(Integer value1, Integer value2) {
            addCriterion("OrderState not between", value1, value2, "orderstate");
            return (Criteria) this;
        }

        public Criteria andDisabledIsNull() {
            addCriterion("Disabled is null");
            return (Criteria) this;
        }

        public Criteria andDisabledIsNotNull() {
            addCriterion("Disabled is not null");
            return (Criteria) this;
        }

        public Criteria andDisabledEqualTo(Integer value) {
            addCriterion("Disabled =", value, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledNotEqualTo(Integer value) {
            addCriterion("Disabled <>", value, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledGreaterThan(Integer value) {
            addCriterion("Disabled >", value, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledGreaterThanOrEqualTo(Integer value) {
            addCriterion("Disabled >=", value, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledLessThan(Integer value) {
            addCriterion("Disabled <", value, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledLessThanOrEqualTo(Integer value) {
            addCriterion("Disabled <=", value, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledIn(List<Integer> values) {
            addCriterion("Disabled in", values, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledNotIn(List<Integer> values) {
            addCriterion("Disabled not in", values, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledBetween(Integer value1, Integer value2) {
            addCriterion("Disabled between", value1, value2, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledNotBetween(Integer value1, Integer value2) {
            addCriterion("Disabled not between", value1, value2, "disabled");
            return (Criteria) this;
        }

        public Criteria andRecCreatetimeIsNull() {
            addCriterion("Rec_CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andRecCreatetimeIsNotNull() {
            addCriterion("Rec_CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andRecCreatetimeEqualTo(Date value) {
            addCriterion("Rec_CreateTime =", value, "recCreatetime");
            return (Criteria) this;
        }

        public Criteria andRecCreatetimeNotEqualTo(Date value) {
            addCriterion("Rec_CreateTime <>", value, "recCreatetime");
            return (Criteria) this;
        }

        public Criteria andRecCreatetimeGreaterThan(Date value) {
            addCriterion("Rec_CreateTime >", value, "recCreatetime");
            return (Criteria) this;
        }

        public Criteria andRecCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("Rec_CreateTime >=", value, "recCreatetime");
            return (Criteria) this;
        }

        public Criteria andRecCreatetimeLessThan(Date value) {
            addCriterion("Rec_CreateTime <", value, "recCreatetime");
            return (Criteria) this;
        }

        public Criteria andRecCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("Rec_CreateTime <=", value, "recCreatetime");
            return (Criteria) this;
        }

        public Criteria andRecCreatetimeIn(List<Date> values) {
            addCriterion("Rec_CreateTime in", values, "recCreatetime");
            return (Criteria) this;
        }

        public Criteria andRecCreatetimeNotIn(List<Date> values) {
            addCriterion("Rec_CreateTime not in", values, "recCreatetime");
            return (Criteria) this;
        }

        public Criteria andRecCreatetimeBetween(Date value1, Date value2) {
            addCriterion("Rec_CreateTime between", value1, value2, "recCreatetime");
            return (Criteria) this;
        }

        public Criteria andRecCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("Rec_CreateTime not between", value1, value2, "recCreatetime");
            return (Criteria) this;
        }

        public Criteria andRecCreatebyIsNull() {
            addCriterion("Rec_CreateBy is null");
            return (Criteria) this;
        }

        public Criteria andRecCreatebyIsNotNull() {
            addCriterion("Rec_CreateBy is not null");
            return (Criteria) this;
        }

        public Criteria andRecCreatebyEqualTo(String value) {
            addCriterion("Rec_CreateBy =", value, "recCreateby");
            return (Criteria) this;
        }

        public Criteria andRecCreatebyNotEqualTo(String value) {
            addCriterion("Rec_CreateBy <>", value, "recCreateby");
            return (Criteria) this;
        }

        public Criteria andRecCreatebyGreaterThan(String value) {
            addCriterion("Rec_CreateBy >", value, "recCreateby");
            return (Criteria) this;
        }

        public Criteria andRecCreatebyGreaterThanOrEqualTo(String value) {
            addCriterion("Rec_CreateBy >=", value, "recCreateby");
            return (Criteria) this;
        }

        public Criteria andRecCreatebyLessThan(String value) {
            addCriterion("Rec_CreateBy <", value, "recCreateby");
            return (Criteria) this;
        }

        public Criteria andRecCreatebyLessThanOrEqualTo(String value) {
            addCriterion("Rec_CreateBy <=", value, "recCreateby");
            return (Criteria) this;
        }

        public Criteria andRecCreatebyLike(String value) {
            addCriterion("Rec_CreateBy like", value, "recCreateby");
            return (Criteria) this;
        }

        public Criteria andRecCreatebyNotLike(String value) {
            addCriterion("Rec_CreateBy not like", value, "recCreateby");
            return (Criteria) this;
        }

        public Criteria andRecCreatebyIn(List<String> values) {
            addCriterion("Rec_CreateBy in", values, "recCreateby");
            return (Criteria) this;
        }

        public Criteria andRecCreatebyNotIn(List<String> values) {
            addCriterion("Rec_CreateBy not in", values, "recCreateby");
            return (Criteria) this;
        }

        public Criteria andRecCreatebyBetween(String value1, String value2) {
            addCriterion("Rec_CreateBy between", value1, value2, "recCreateby");
            return (Criteria) this;
        }

        public Criteria andRecCreatebyNotBetween(String value1, String value2) {
            addCriterion("Rec_CreateBy not between", value1, value2, "recCreateby");
            return (Criteria) this;
        }

        public Criteria andRecModifytimeIsNull() {
            addCriterion("Rec_ModifyTime is null");
            return (Criteria) this;
        }

        public Criteria andRecModifytimeIsNotNull() {
            addCriterion("Rec_ModifyTime is not null");
            return (Criteria) this;
        }

        public Criteria andRecModifytimeEqualTo(Date value) {
            addCriterion("Rec_ModifyTime =", value, "recModifytime");
            return (Criteria) this;
        }

        public Criteria andRecModifytimeNotEqualTo(Date value) {
            addCriterion("Rec_ModifyTime <>", value, "recModifytime");
            return (Criteria) this;
        }

        public Criteria andRecModifytimeGreaterThan(Date value) {
            addCriterion("Rec_ModifyTime >", value, "recModifytime");
            return (Criteria) this;
        }

        public Criteria andRecModifytimeGreaterThanOrEqualTo(Date value) {
            addCriterion("Rec_ModifyTime >=", value, "recModifytime");
            return (Criteria) this;
        }

        public Criteria andRecModifytimeLessThan(Date value) {
            addCriterion("Rec_ModifyTime <", value, "recModifytime");
            return (Criteria) this;
        }

        public Criteria andRecModifytimeLessThanOrEqualTo(Date value) {
            addCriterion("Rec_ModifyTime <=", value, "recModifytime");
            return (Criteria) this;
        }

        public Criteria andRecModifytimeIn(List<Date> values) {
            addCriterion("Rec_ModifyTime in", values, "recModifytime");
            return (Criteria) this;
        }

        public Criteria andRecModifytimeNotIn(List<Date> values) {
            addCriterion("Rec_ModifyTime not in", values, "recModifytime");
            return (Criteria) this;
        }

        public Criteria andRecModifytimeBetween(Date value1, Date value2) {
            addCriterion("Rec_ModifyTime between", value1, value2, "recModifytime");
            return (Criteria) this;
        }

        public Criteria andRecModifytimeNotBetween(Date value1, Date value2) {
            addCriterion("Rec_ModifyTime not between", value1, value2, "recModifytime");
            return (Criteria) this;
        }

        public Criteria andRecModifybyIsNull() {
            addCriterion("Rec_ModifyBy is null");
            return (Criteria) this;
        }

        public Criteria andRecModifybyIsNotNull() {
            addCriterion("Rec_ModifyBy is not null");
            return (Criteria) this;
        }

        public Criteria andRecModifybyEqualTo(String value) {
            addCriterion("Rec_ModifyBy =", value, "recModifyby");
            return (Criteria) this;
        }

        public Criteria andRecModifybyNotEqualTo(String value) {
            addCriterion("Rec_ModifyBy <>", value, "recModifyby");
            return (Criteria) this;
        }

        public Criteria andRecModifybyGreaterThan(String value) {
            addCriterion("Rec_ModifyBy >", value, "recModifyby");
            return (Criteria) this;
        }

        public Criteria andRecModifybyGreaterThanOrEqualTo(String value) {
            addCriterion("Rec_ModifyBy >=", value, "recModifyby");
            return (Criteria) this;
        }

        public Criteria andRecModifybyLessThan(String value) {
            addCriterion("Rec_ModifyBy <", value, "recModifyby");
            return (Criteria) this;
        }

        public Criteria andRecModifybyLessThanOrEqualTo(String value) {
            addCriterion("Rec_ModifyBy <=", value, "recModifyby");
            return (Criteria) this;
        }

        public Criteria andRecModifybyLike(String value) {
            addCriterion("Rec_ModifyBy like", value, "recModifyby");
            return (Criteria) this;
        }

        public Criteria andRecModifybyNotLike(String value) {
            addCriterion("Rec_ModifyBy not like", value, "recModifyby");
            return (Criteria) this;
        }

        public Criteria andRecModifybyIn(List<String> values) {
            addCriterion("Rec_ModifyBy in", values, "recModifyby");
            return (Criteria) this;
        }

        public Criteria andRecModifybyNotIn(List<String> values) {
            addCriterion("Rec_ModifyBy not in", values, "recModifyby");
            return (Criteria) this;
        }

        public Criteria andRecModifybyBetween(String value1, String value2) {
            addCriterion("Rec_ModifyBy between", value1, value2, "recModifyby");
            return (Criteria) this;
        }

        public Criteria andRecModifybyNotBetween(String value1, String value2) {
            addCriterion("Rec_ModifyBy not between", value1, value2, "recModifyby");
            return (Criteria) this;
        }

        public Criteria andReferencecodeIsNull() {
            addCriterion("ReferenceCode is null");
            return (Criteria) this;
        }

        public Criteria andReferencecodeIsNotNull() {
            addCriterion("ReferenceCode is not null");
            return (Criteria) this;
        }

        public Criteria andReferencecodeEqualTo(String value) {
            addCriterion("ReferenceCode =", value, "referencecode");
            return (Criteria) this;
        }

        public Criteria andReferencecodeNotEqualTo(String value) {
            addCriterion("ReferenceCode <>", value, "referencecode");
            return (Criteria) this;
        }

        public Criteria andReferencecodeGreaterThan(String value) {
            addCriterion("ReferenceCode >", value, "referencecode");
            return (Criteria) this;
        }

        public Criteria andReferencecodeGreaterThanOrEqualTo(String value) {
            addCriterion("ReferenceCode >=", value, "referencecode");
            return (Criteria) this;
        }

        public Criteria andReferencecodeLessThan(String value) {
            addCriterion("ReferenceCode <", value, "referencecode");
            return (Criteria) this;
        }

        public Criteria andReferencecodeLessThanOrEqualTo(String value) {
            addCriterion("ReferenceCode <=", value, "referencecode");
            return (Criteria) this;
        }

        public Criteria andReferencecodeLike(String value) {
            addCriterion("ReferenceCode like", value, "referencecode");
            return (Criteria) this;
        }

        public Criteria andReferencecodeNotLike(String value) {
            addCriterion("ReferenceCode not like", value, "referencecode");
            return (Criteria) this;
        }

        public Criteria andReferencecodeIn(List<String> values) {
            addCriterion("ReferenceCode in", values, "referencecode");
            return (Criteria) this;
        }

        public Criteria andReferencecodeNotIn(List<String> values) {
            addCriterion("ReferenceCode not in", values, "referencecode");
            return (Criteria) this;
        }

        public Criteria andReferencecodeBetween(String value1, String value2) {
            addCriterion("ReferenceCode between", value1, value2, "referencecode");
            return (Criteria) this;
        }

        public Criteria andReferencecodeNotBetween(String value1, String value2) {
            addCriterion("ReferenceCode not between", value1, value2, "referencecode");
            return (Criteria) this;
        }

        public Criteria andNotesIsNull() {
            addCriterion("Notes is null");
            return (Criteria) this;
        }

        public Criteria andNotesIsNotNull() {
            addCriterion("Notes is not null");
            return (Criteria) this;
        }

        public Criteria andNotesEqualTo(String value) {
            addCriterion("Notes =", value, "notes");
            return (Criteria) this;
        }

        public Criteria andNotesNotEqualTo(String value) {
            addCriterion("Notes <>", value, "notes");
            return (Criteria) this;
        }

        public Criteria andNotesGreaterThan(String value) {
            addCriterion("Notes >", value, "notes");
            return (Criteria) this;
        }

        public Criteria andNotesGreaterThanOrEqualTo(String value) {
            addCriterion("Notes >=", value, "notes");
            return (Criteria) this;
        }

        public Criteria andNotesLessThan(String value) {
            addCriterion("Notes <", value, "notes");
            return (Criteria) this;
        }

        public Criteria andNotesLessThanOrEqualTo(String value) {
            addCriterion("Notes <=", value, "notes");
            return (Criteria) this;
        }

        public Criteria andNotesLike(String value) {
            addCriterion("Notes like", value, "notes");
            return (Criteria) this;
        }

        public Criteria andNotesNotLike(String value) {
            addCriterion("Notes not like", value, "notes");
            return (Criteria) this;
        }

        public Criteria andNotesIn(List<String> values) {
            addCriterion("Notes in", values, "notes");
            return (Criteria) this;
        }

        public Criteria andNotesNotIn(List<String> values) {
            addCriterion("Notes not in", values, "notes");
            return (Criteria) this;
        }

        public Criteria andNotesBetween(String value1, String value2) {
            addCriterion("Notes between", value1, value2, "notes");
            return (Criteria) this;
        }

        public Criteria andNotesNotBetween(String value1, String value2) {
            addCriterion("Notes not between", value1, value2, "notes");
            return (Criteria) this;
        }

        public Criteria andShipmentstateIsNull() {
            addCriterion("ShipmentState is null");
            return (Criteria) this;
        }

        public Criteria andShipmentstateIsNotNull() {
            addCriterion("ShipmentState is not null");
            return (Criteria) this;
        }

        public Criteria andShipmentstateEqualTo(Integer value) {
            addCriterion("ShipmentState =", value, "shipmentstate");
            return (Criteria) this;
        }

        public Criteria andShipmentstateNotEqualTo(Integer value) {
            addCriterion("ShipmentState <>", value, "shipmentstate");
            return (Criteria) this;
        }

        public Criteria andShipmentstateGreaterThan(Integer value) {
            addCriterion("ShipmentState >", value, "shipmentstate");
            return (Criteria) this;
        }

        public Criteria andShipmentstateGreaterThanOrEqualTo(Integer value) {
            addCriterion("ShipmentState >=", value, "shipmentstate");
            return (Criteria) this;
        }

        public Criteria andShipmentstateLessThan(Integer value) {
            addCriterion("ShipmentState <", value, "shipmentstate");
            return (Criteria) this;
        }

        public Criteria andShipmentstateLessThanOrEqualTo(Integer value) {
            addCriterion("ShipmentState <=", value, "shipmentstate");
            return (Criteria) this;
        }

        public Criteria andShipmentstateIn(List<Integer> values) {
            addCriterion("ShipmentState in", values, "shipmentstate");
            return (Criteria) this;
        }

        public Criteria andShipmentstateNotIn(List<Integer> values) {
            addCriterion("ShipmentState not in", values, "shipmentstate");
            return (Criteria) this;
        }

        public Criteria andShipmentstateBetween(Integer value1, Integer value2) {
            addCriterion("ShipmentState between", value1, value2, "shipmentstate");
            return (Criteria) this;
        }

        public Criteria andShipmentstateNotBetween(Integer value1, Integer value2) {
            addCriterion("ShipmentState not between", value1, value2, "shipmentstate");
            return (Criteria) this;
        }

        public Criteria andDeliverybeginIsNull() {
            addCriterion("DeliveryBegin is null");
            return (Criteria) this;
        }

        public Criteria andDeliverybeginIsNotNull() {
            addCriterion("DeliveryBegin is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverybeginEqualTo(Date value) {
            addCriterion("DeliveryBegin =", value, "deliverybegin");
            return (Criteria) this;
        }

        public Criteria andDeliverybeginNotEqualTo(Date value) {
            addCriterion("DeliveryBegin <>", value, "deliverybegin");
            return (Criteria) this;
        }

        public Criteria andDeliverybeginGreaterThan(Date value) {
            addCriterion("DeliveryBegin >", value, "deliverybegin");
            return (Criteria) this;
        }

        public Criteria andDeliverybeginGreaterThanOrEqualTo(Date value) {
            addCriterion("DeliveryBegin >=", value, "deliverybegin");
            return (Criteria) this;
        }

        public Criteria andDeliverybeginLessThan(Date value) {
            addCriterion("DeliveryBegin <", value, "deliverybegin");
            return (Criteria) this;
        }

        public Criteria andDeliverybeginLessThanOrEqualTo(Date value) {
            addCriterion("DeliveryBegin <=", value, "deliverybegin");
            return (Criteria) this;
        }

        public Criteria andDeliverybeginIn(List<Date> values) {
            addCriterion("DeliveryBegin in", values, "deliverybegin");
            return (Criteria) this;
        }

        public Criteria andDeliverybeginNotIn(List<Date> values) {
            addCriterion("DeliveryBegin not in", values, "deliverybegin");
            return (Criteria) this;
        }

        public Criteria andDeliverybeginBetween(Date value1, Date value2) {
            addCriterion("DeliveryBegin between", value1, value2, "deliverybegin");
            return (Criteria) this;
        }

        public Criteria andDeliverybeginNotBetween(Date value1, Date value2) {
            addCriterion("DeliveryBegin not between", value1, value2, "deliverybegin");
            return (Criteria) this;
        }

        public Criteria andDeliveryendIsNull() {
            addCriterion("DeliveryEnd is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryendIsNotNull() {
            addCriterion("DeliveryEnd is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryendEqualTo(Date value) {
            addCriterion("DeliveryEnd =", value, "deliveryend");
            return (Criteria) this;
        }

        public Criteria andDeliveryendNotEqualTo(Date value) {
            addCriterion("DeliveryEnd <>", value, "deliveryend");
            return (Criteria) this;
        }

        public Criteria andDeliveryendGreaterThan(Date value) {
            addCriterion("DeliveryEnd >", value, "deliveryend");
            return (Criteria) this;
        }

        public Criteria andDeliveryendGreaterThanOrEqualTo(Date value) {
            addCriterion("DeliveryEnd >=", value, "deliveryend");
            return (Criteria) this;
        }

        public Criteria andDeliveryendLessThan(Date value) {
            addCriterion("DeliveryEnd <", value, "deliveryend");
            return (Criteria) this;
        }

        public Criteria andDeliveryendLessThanOrEqualTo(Date value) {
            addCriterion("DeliveryEnd <=", value, "deliveryend");
            return (Criteria) this;
        }

        public Criteria andDeliveryendIn(List<Date> values) {
            addCriterion("DeliveryEnd in", values, "deliveryend");
            return (Criteria) this;
        }

        public Criteria andDeliveryendNotIn(List<Date> values) {
            addCriterion("DeliveryEnd not in", values, "deliveryend");
            return (Criteria) this;
        }

        public Criteria andDeliveryendBetween(Date value1, Date value2) {
            addCriterion("DeliveryEnd between", value1, value2, "deliveryend");
            return (Criteria) this;
        }

        public Criteria andDeliveryendNotBetween(Date value1, Date value2) {
            addCriterion("DeliveryEnd not between", value1, value2, "deliveryend");
            return (Criteria) this;
        }

        public Criteria andDeliverycodeIsNull() {
            addCriterion("DeliveryCode is null");
            return (Criteria) this;
        }

        public Criteria andDeliverycodeIsNotNull() {
            addCriterion("DeliveryCode is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverycodeEqualTo(String value) {
            addCriterion("DeliveryCode =", value, "deliverycode");
            return (Criteria) this;
        }

        public Criteria andDeliverycodeNotEqualTo(String value) {
            addCriterion("DeliveryCode <>", value, "deliverycode");
            return (Criteria) this;
        }

        public Criteria andDeliverycodeGreaterThan(String value) {
            addCriterion("DeliveryCode >", value, "deliverycode");
            return (Criteria) this;
        }

        public Criteria andDeliverycodeGreaterThanOrEqualTo(String value) {
            addCriterion("DeliveryCode >=", value, "deliverycode");
            return (Criteria) this;
        }

        public Criteria andDeliverycodeLessThan(String value) {
            addCriterion("DeliveryCode <", value, "deliverycode");
            return (Criteria) this;
        }

        public Criteria andDeliverycodeLessThanOrEqualTo(String value) {
            addCriterion("DeliveryCode <=", value, "deliverycode");
            return (Criteria) this;
        }

        public Criteria andDeliverycodeLike(String value) {
            addCriterion("DeliveryCode like", value, "deliverycode");
            return (Criteria) this;
        }

        public Criteria andDeliverycodeNotLike(String value) {
            addCriterion("DeliveryCode not like", value, "deliverycode");
            return (Criteria) this;
        }

        public Criteria andDeliverycodeIn(List<String> values) {
            addCriterion("DeliveryCode in", values, "deliverycode");
            return (Criteria) this;
        }

        public Criteria andDeliverycodeNotIn(List<String> values) {
            addCriterion("DeliveryCode not in", values, "deliverycode");
            return (Criteria) this;
        }

        public Criteria andDeliverycodeBetween(String value1, String value2) {
            addCriterion("DeliveryCode between", value1, value2, "deliverycode");
            return (Criteria) this;
        }

        public Criteria andDeliverycodeNotBetween(String value1, String value2) {
            addCriterion("DeliveryCode not between", value1, value2, "deliverycode");
            return (Criteria) this;
        }

        public Criteria andOrdertitleIsNull() {
            addCriterion("OrderTitle is null");
            return (Criteria) this;
        }

        public Criteria andOrdertitleIsNotNull() {
            addCriterion("OrderTitle is not null");
            return (Criteria) this;
        }

        public Criteria andOrdertitleEqualTo(String value) {
            addCriterion("OrderTitle =", value, "ordertitle");
            return (Criteria) this;
        }

        public Criteria andOrdertitleNotEqualTo(String value) {
            addCriterion("OrderTitle <>", value, "ordertitle");
            return (Criteria) this;
        }

        public Criteria andOrdertitleGreaterThan(String value) {
            addCriterion("OrderTitle >", value, "ordertitle");
            return (Criteria) this;
        }

        public Criteria andOrdertitleGreaterThanOrEqualTo(String value) {
            addCriterion("OrderTitle >=", value, "ordertitle");
            return (Criteria) this;
        }

        public Criteria andOrdertitleLessThan(String value) {
            addCriterion("OrderTitle <", value, "ordertitle");
            return (Criteria) this;
        }

        public Criteria andOrdertitleLessThanOrEqualTo(String value) {
            addCriterion("OrderTitle <=", value, "ordertitle");
            return (Criteria) this;
        }

        public Criteria andOrdertitleLike(String value) {
            addCriterion("OrderTitle like", value, "ordertitle");
            return (Criteria) this;
        }

        public Criteria andOrdertitleNotLike(String value) {
            addCriterion("OrderTitle not like", value, "ordertitle");
            return (Criteria) this;
        }

        public Criteria andOrdertitleIn(List<String> values) {
            addCriterion("OrderTitle in", values, "ordertitle");
            return (Criteria) this;
        }

        public Criteria andOrdertitleNotIn(List<String> values) {
            addCriterion("OrderTitle not in", values, "ordertitle");
            return (Criteria) this;
        }

        public Criteria andOrdertitleBetween(String value1, String value2) {
            addCriterion("OrderTitle between", value1, value2, "ordertitle");
            return (Criteria) this;
        }

        public Criteria andOrdertitleNotBetween(String value1, String value2) {
            addCriterion("OrderTitle not between", value1, value2, "ordertitle");
            return (Criteria) this;
        }

        public Criteria andReceiverlatIsNull() {
            addCriterion("ReceiverLat is null");
            return (Criteria) this;
        }

        public Criteria andReceiverlatIsNotNull() {
            addCriterion("ReceiverLat is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverlatEqualTo(String value) {
            addCriterion("ReceiverLat =", value, "receiverlat");
            return (Criteria) this;
        }

        public Criteria andReceiverlatNotEqualTo(String value) {
            addCriterion("ReceiverLat <>", value, "receiverlat");
            return (Criteria) this;
        }

        public Criteria andReceiverlatGreaterThan(String value) {
            addCriterion("ReceiverLat >", value, "receiverlat");
            return (Criteria) this;
        }

        public Criteria andReceiverlatGreaterThanOrEqualTo(String value) {
            addCriterion("ReceiverLat >=", value, "receiverlat");
            return (Criteria) this;
        }

        public Criteria andReceiverlatLessThan(String value) {
            addCriterion("ReceiverLat <", value, "receiverlat");
            return (Criteria) this;
        }

        public Criteria andReceiverlatLessThanOrEqualTo(String value) {
            addCriterion("ReceiverLat <=", value, "receiverlat");
            return (Criteria) this;
        }

        public Criteria andReceiverlatLike(String value) {
            addCriterion("ReceiverLat like", value, "receiverlat");
            return (Criteria) this;
        }

        public Criteria andReceiverlatNotLike(String value) {
            addCriterion("ReceiverLat not like", value, "receiverlat");
            return (Criteria) this;
        }

        public Criteria andReceiverlatIn(List<String> values) {
            addCriterion("ReceiverLat in", values, "receiverlat");
            return (Criteria) this;
        }

        public Criteria andReceiverlatNotIn(List<String> values) {
            addCriterion("ReceiverLat not in", values, "receiverlat");
            return (Criteria) this;
        }

        public Criteria andReceiverlatBetween(String value1, String value2) {
            addCriterion("ReceiverLat between", value1, value2, "receiverlat");
            return (Criteria) this;
        }

        public Criteria andReceiverlatNotBetween(String value1, String value2) {
            addCriterion("ReceiverLat not between", value1, value2, "receiverlat");
            return (Criteria) this;
        }

        public Criteria andReceiverlngIsNull() {
            addCriterion("ReceiverLng is null");
            return (Criteria) this;
        }

        public Criteria andReceiverlngIsNotNull() {
            addCriterion("ReceiverLng is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverlngEqualTo(String value) {
            addCriterion("ReceiverLng =", value, "receiverlng");
            return (Criteria) this;
        }

        public Criteria andReceiverlngNotEqualTo(String value) {
            addCriterion("ReceiverLng <>", value, "receiverlng");
            return (Criteria) this;
        }

        public Criteria andReceiverlngGreaterThan(String value) {
            addCriterion("ReceiverLng >", value, "receiverlng");
            return (Criteria) this;
        }

        public Criteria andReceiverlngGreaterThanOrEqualTo(String value) {
            addCriterion("ReceiverLng >=", value, "receiverlng");
            return (Criteria) this;
        }

        public Criteria andReceiverlngLessThan(String value) {
            addCriterion("ReceiverLng <", value, "receiverlng");
            return (Criteria) this;
        }

        public Criteria andReceiverlngLessThanOrEqualTo(String value) {
            addCriterion("ReceiverLng <=", value, "receiverlng");
            return (Criteria) this;
        }

        public Criteria andReceiverlngLike(String value) {
            addCriterion("ReceiverLng like", value, "receiverlng");
            return (Criteria) this;
        }

        public Criteria andReceiverlngNotLike(String value) {
            addCriterion("ReceiverLng not like", value, "receiverlng");
            return (Criteria) this;
        }

        public Criteria andReceiverlngIn(List<String> values) {
            addCriterion("ReceiverLng in", values, "receiverlng");
            return (Criteria) this;
        }

        public Criteria andReceiverlngNotIn(List<String> values) {
            addCriterion("ReceiverLng not in", values, "receiverlng");
            return (Criteria) this;
        }

        public Criteria andReceiverlngBetween(String value1, String value2) {
            addCriterion("ReceiverLng between", value1, value2, "receiverlng");
            return (Criteria) this;
        }

        public Criteria andReceiverlngNotBetween(String value1, String value2) {
            addCriterion("ReceiverLng not between", value1, value2, "receiverlng");
            return (Criteria) this;
        }

        public Criteria andDeliverytypeIsNull() {
            addCriterion("DeliveryType is null");
            return (Criteria) this;
        }

        public Criteria andDeliverytypeIsNotNull() {
            addCriterion("DeliveryType is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverytypeEqualTo(Integer value) {
            addCriterion("DeliveryType =", value, "deliverytype");
            return (Criteria) this;
        }

        public Criteria andDeliverytypeNotEqualTo(Integer value) {
            addCriterion("DeliveryType <>", value, "deliverytype");
            return (Criteria) this;
        }

        public Criteria andDeliverytypeGreaterThan(Integer value) {
            addCriterion("DeliveryType >", value, "deliverytype");
            return (Criteria) this;
        }

        public Criteria andDeliverytypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("DeliveryType >=", value, "deliverytype");
            return (Criteria) this;
        }

        public Criteria andDeliverytypeLessThan(Integer value) {
            addCriterion("DeliveryType <", value, "deliverytype");
            return (Criteria) this;
        }

        public Criteria andDeliverytypeLessThanOrEqualTo(Integer value) {
            addCriterion("DeliveryType <=", value, "deliverytype");
            return (Criteria) this;
        }

        public Criteria andDeliverytypeIn(List<Integer> values) {
            addCriterion("DeliveryType in", values, "deliverytype");
            return (Criteria) this;
        }

        public Criteria andDeliverytypeNotIn(List<Integer> values) {
            addCriterion("DeliveryType not in", values, "deliverytype");
            return (Criteria) this;
        }

        public Criteria andDeliverytypeBetween(Integer value1, Integer value2) {
            addCriterion("DeliveryType between", value1, value2, "deliverytype");
            return (Criteria) this;
        }

        public Criteria andDeliverytypeNotBetween(Integer value1, Integer value2) {
            addCriterion("DeliveryType not between", value1, value2, "deliverytype");
            return (Criteria) this;
        }

        public Criteria andFreightIsNull() {
            addCriterion("Freight is null");
            return (Criteria) this;
        }

        public Criteria andFreightIsNotNull() {
            addCriterion("Freight is not null");
            return (Criteria) this;
        }

        public Criteria andFreightEqualTo(Double value) {
            addCriterion("Freight =", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightNotEqualTo(Double value) {
            addCriterion("Freight <>", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightGreaterThan(Double value) {
            addCriterion("Freight >", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightGreaterThanOrEqualTo(Double value) {
            addCriterion("Freight >=", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightLessThan(Double value) {
            addCriterion("Freight <", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightLessThanOrEqualTo(Double value) {
            addCriterion("Freight <=", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightIn(List<Double> values) {
            addCriterion("Freight in", values, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightNotIn(List<Double> values) {
            addCriterion("Freight not in", values, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightBetween(Double value1, Double value2) {
            addCriterion("Freight between", value1, value2, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightNotBetween(Double value1, Double value2) {
            addCriterion("Freight not between", value1, value2, "freight");
            return (Criteria) this;
        }

        public Criteria andShopcodeIsNull() {
            addCriterion("ShopCode is null");
            return (Criteria) this;
        }

        public Criteria andShopcodeIsNotNull() {
            addCriterion("ShopCode is not null");
            return (Criteria) this;
        }

        public Criteria andShopcodeEqualTo(String value) {
            addCriterion("ShopCode =", value, "shopcode");
            return (Criteria) this;
        }

        public Criteria andShopcodeNotEqualTo(String value) {
            addCriterion("ShopCode <>", value, "shopcode");
            return (Criteria) this;
        }

        public Criteria andShopcodeGreaterThan(String value) {
            addCriterion("ShopCode >", value, "shopcode");
            return (Criteria) this;
        }

        public Criteria andShopcodeGreaterThanOrEqualTo(String value) {
            addCriterion("ShopCode >=", value, "shopcode");
            return (Criteria) this;
        }

        public Criteria andShopcodeLessThan(String value) {
            addCriterion("ShopCode <", value, "shopcode");
            return (Criteria) this;
        }

        public Criteria andShopcodeLessThanOrEqualTo(String value) {
            addCriterion("ShopCode <=", value, "shopcode");
            return (Criteria) this;
        }

        public Criteria andShopcodeLike(String value) {
            addCriterion("ShopCode like", value, "shopcode");
            return (Criteria) this;
        }

        public Criteria andShopcodeNotLike(String value) {
            addCriterion("ShopCode not like", value, "shopcode");
            return (Criteria) this;
        }

        public Criteria andShopcodeIn(List<String> values) {
            addCriterion("ShopCode in", values, "shopcode");
            return (Criteria) this;
        }

        public Criteria andShopcodeNotIn(List<String> values) {
            addCriterion("ShopCode not in", values, "shopcode");
            return (Criteria) this;
        }

        public Criteria andShopcodeBetween(String value1, String value2) {
            addCriterion("ShopCode between", value1, value2, "shopcode");
            return (Criteria) this;
        }

        public Criteria andShopcodeNotBetween(String value1, String value2) {
            addCriterion("ShopCode not between", value1, value2, "shopcode");
            return (Criteria) this;
        }

        public Criteria andShopnameIsNull() {
            addCriterion("ShopName is null");
            return (Criteria) this;
        }

        public Criteria andShopnameIsNotNull() {
            addCriterion("ShopName is not null");
            return (Criteria) this;
        }

        public Criteria andShopnameEqualTo(String value) {
            addCriterion("ShopName =", value, "shopname");
            return (Criteria) this;
        }

        public Criteria andShopnameNotEqualTo(String value) {
            addCriterion("ShopName <>", value, "shopname");
            return (Criteria) this;
        }

        public Criteria andShopnameGreaterThan(String value) {
            addCriterion("ShopName >", value, "shopname");
            return (Criteria) this;
        }

        public Criteria andShopnameGreaterThanOrEqualTo(String value) {
            addCriterion("ShopName >=", value, "shopname");
            return (Criteria) this;
        }

        public Criteria andShopnameLessThan(String value) {
            addCriterion("ShopName <", value, "shopname");
            return (Criteria) this;
        }

        public Criteria andShopnameLessThanOrEqualTo(String value) {
            addCriterion("ShopName <=", value, "shopname");
            return (Criteria) this;
        }

        public Criteria andShopnameLike(String value) {
            addCriterion("ShopName like", value, "shopname");
            return (Criteria) this;
        }

        public Criteria andShopnameNotLike(String value) {
            addCriterion("ShopName not like", value, "shopname");
            return (Criteria) this;
        }

        public Criteria andShopnameIn(List<String> values) {
            addCriterion("ShopName in", values, "shopname");
            return (Criteria) this;
        }

        public Criteria andShopnameNotIn(List<String> values) {
            addCriterion("ShopName not in", values, "shopname");
            return (Criteria) this;
        }

        public Criteria andShopnameBetween(String value1, String value2) {
            addCriterion("ShopName between", value1, value2, "shopname");
            return (Criteria) this;
        }

        public Criteria andShopnameNotBetween(String value1, String value2) {
            addCriterion("ShopName not between", value1, value2, "shopname");
            return (Criteria) this;
        }

        public Criteria andCustomerfreightIsNull() {
            addCriterion("CustomerFreight is null");
            return (Criteria) this;
        }

        public Criteria andCustomerfreightIsNotNull() {
            addCriterion("CustomerFreight is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerfreightEqualTo(Double value) {
            addCriterion("CustomerFreight =", value, "customerfreight");
            return (Criteria) this;
        }

        public Criteria andCustomerfreightNotEqualTo(Double value) {
            addCriterion("CustomerFreight <>", value, "customerfreight");
            return (Criteria) this;
        }

        public Criteria andCustomerfreightGreaterThan(Double value) {
            addCriterion("CustomerFreight >", value, "customerfreight");
            return (Criteria) this;
        }

        public Criteria andCustomerfreightGreaterThanOrEqualTo(Double value) {
            addCriterion("CustomerFreight >=", value, "customerfreight");
            return (Criteria) this;
        }

        public Criteria andCustomerfreightLessThan(Double value) {
            addCriterion("CustomerFreight <", value, "customerfreight");
            return (Criteria) this;
        }

        public Criteria andCustomerfreightLessThanOrEqualTo(Double value) {
            addCriterion("CustomerFreight <=", value, "customerfreight");
            return (Criteria) this;
        }

        public Criteria andCustomerfreightIn(List<Double> values) {
            addCriterion("CustomerFreight in", values, "customerfreight");
            return (Criteria) this;
        }

        public Criteria andCustomerfreightNotIn(List<Double> values) {
            addCriterion("CustomerFreight not in", values, "customerfreight");
            return (Criteria) this;
        }

        public Criteria andCustomerfreightBetween(Double value1, Double value2) {
            addCriterion("CustomerFreight between", value1, value2, "customerfreight");
            return (Criteria) this;
        }

        public Criteria andCustomerfreightNotBetween(Double value1, Double value2) {
            addCriterion("CustomerFreight not between", value1, value2, "customerfreight");
            return (Criteria) this;
        }

        public Criteria andCarrierfreightIsNull() {
            addCriterion("CarrierFreight is null");
            return (Criteria) this;
        }

        public Criteria andCarrierfreightIsNotNull() {
            addCriterion("CarrierFreight is not null");
            return (Criteria) this;
        }

        public Criteria andCarrierfreightEqualTo(Double value) {
            addCriterion("CarrierFreight =", value, "carrierfreight");
            return (Criteria) this;
        }

        public Criteria andCarrierfreightNotEqualTo(Double value) {
            addCriterion("CarrierFreight <>", value, "carrierfreight");
            return (Criteria) this;
        }

        public Criteria andCarrierfreightGreaterThan(Double value) {
            addCriterion("CarrierFreight >", value, "carrierfreight");
            return (Criteria) this;
        }

        public Criteria andCarrierfreightGreaterThanOrEqualTo(Double value) {
            addCriterion("CarrierFreight >=", value, "carrierfreight");
            return (Criteria) this;
        }

        public Criteria andCarrierfreightLessThan(Double value) {
            addCriterion("CarrierFreight <", value, "carrierfreight");
            return (Criteria) this;
        }

        public Criteria andCarrierfreightLessThanOrEqualTo(Double value) {
            addCriterion("CarrierFreight <=", value, "carrierfreight");
            return (Criteria) this;
        }

        public Criteria andCarrierfreightIn(List<Double> values) {
            addCriterion("CarrierFreight in", values, "carrierfreight");
            return (Criteria) this;
        }

        public Criteria andCarrierfreightNotIn(List<Double> values) {
            addCriterion("CarrierFreight not in", values, "carrierfreight");
            return (Criteria) this;
        }

        public Criteria andCarrierfreightBetween(Double value1, Double value2) {
            addCriterion("CarrierFreight between", value1, value2, "carrierfreight");
            return (Criteria) this;
        }

        public Criteria andCarrierfreightNotBetween(Double value1, Double value2) {
            addCriterion("CarrierFreight not between", value1, value2, "carrierfreight");
            return (Criteria) this;
        }

        public Criteria andShoplatIsNull() {
            addCriterion("ShopLat is null");
            return (Criteria) this;
        }

        public Criteria andShoplatIsNotNull() {
            addCriterion("ShopLat is not null");
            return (Criteria) this;
        }

        public Criteria andShoplatEqualTo(String value) {
            addCriterion("ShopLat =", value, "shoplat");
            return (Criteria) this;
        }

        public Criteria andShoplatNotEqualTo(String value) {
            addCriterion("ShopLat <>", value, "shoplat");
            return (Criteria) this;
        }

        public Criteria andShoplatGreaterThan(String value) {
            addCriterion("ShopLat >", value, "shoplat");
            return (Criteria) this;
        }

        public Criteria andShoplatGreaterThanOrEqualTo(String value) {
            addCriterion("ShopLat >=", value, "shoplat");
            return (Criteria) this;
        }

        public Criteria andShoplatLessThan(String value) {
            addCriterion("ShopLat <", value, "shoplat");
            return (Criteria) this;
        }

        public Criteria andShoplatLessThanOrEqualTo(String value) {
            addCriterion("ShopLat <=", value, "shoplat");
            return (Criteria) this;
        }

        public Criteria andShoplatLike(String value) {
            addCriterion("ShopLat like", value, "shoplat");
            return (Criteria) this;
        }

        public Criteria andShoplatNotLike(String value) {
            addCriterion("ShopLat not like", value, "shoplat");
            return (Criteria) this;
        }

        public Criteria andShoplatIn(List<String> values) {
            addCriterion("ShopLat in", values, "shoplat");
            return (Criteria) this;
        }

        public Criteria andShoplatNotIn(List<String> values) {
            addCriterion("ShopLat not in", values, "shoplat");
            return (Criteria) this;
        }

        public Criteria andShoplatBetween(String value1, String value2) {
            addCriterion("ShopLat between", value1, value2, "shoplat");
            return (Criteria) this;
        }

        public Criteria andShoplatNotBetween(String value1, String value2) {
            addCriterion("ShopLat not between", value1, value2, "shoplat");
            return (Criteria) this;
        }

        public Criteria andShoplngIsNull() {
            addCriterion("ShopLng is null");
            return (Criteria) this;
        }

        public Criteria andShoplngIsNotNull() {
            addCriterion("ShopLng is not null");
            return (Criteria) this;
        }

        public Criteria andShoplngEqualTo(String value) {
            addCriterion("ShopLng =", value, "shoplng");
            return (Criteria) this;
        }

        public Criteria andShoplngNotEqualTo(String value) {
            addCriterion("ShopLng <>", value, "shoplng");
            return (Criteria) this;
        }

        public Criteria andShoplngGreaterThan(String value) {
            addCriterion("ShopLng >", value, "shoplng");
            return (Criteria) this;
        }

        public Criteria andShoplngGreaterThanOrEqualTo(String value) {
            addCriterion("ShopLng >=", value, "shoplng");
            return (Criteria) this;
        }

        public Criteria andShoplngLessThan(String value) {
            addCriterion("ShopLng <", value, "shoplng");
            return (Criteria) this;
        }

        public Criteria andShoplngLessThanOrEqualTo(String value) {
            addCriterion("ShopLng <=", value, "shoplng");
            return (Criteria) this;
        }

        public Criteria andShoplngLike(String value) {
            addCriterion("ShopLng like", value, "shoplng");
            return (Criteria) this;
        }

        public Criteria andShoplngNotLike(String value) {
            addCriterion("ShopLng not like", value, "shoplng");
            return (Criteria) this;
        }

        public Criteria andShoplngIn(List<String> values) {
            addCriterion("ShopLng in", values, "shoplng");
            return (Criteria) this;
        }

        public Criteria andShoplngNotIn(List<String> values) {
            addCriterion("ShopLng not in", values, "shoplng");
            return (Criteria) this;
        }

        public Criteria andShoplngBetween(String value1, String value2) {
            addCriterion("ShopLng between", value1, value2, "shoplng");
            return (Criteria) this;
        }

        public Criteria andShoplngNotBetween(String value1, String value2) {
            addCriterion("ShopLng not between", value1, value2, "shoplng");
            return (Criteria) this;
        }

        public Criteria andChanneltypeIsNull() {
            addCriterion("ChannelType is null");
            return (Criteria) this;
        }

        public Criteria andChanneltypeIsNotNull() {
            addCriterion("ChannelType is not null");
            return (Criteria) this;
        }

        public Criteria andChanneltypeEqualTo(Integer value) {
            addCriterion("ChannelType =", value, "channeltype");
            return (Criteria) this;
        }

        public Criteria andChanneltypeNotEqualTo(Integer value) {
            addCriterion("ChannelType <>", value, "channeltype");
            return (Criteria) this;
        }

        public Criteria andChanneltypeGreaterThan(Integer value) {
            addCriterion("ChannelType >", value, "channeltype");
            return (Criteria) this;
        }

        public Criteria andChanneltypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("ChannelType >=", value, "channeltype");
            return (Criteria) this;
        }

        public Criteria andChanneltypeLessThan(Integer value) {
            addCriterion("ChannelType <", value, "channeltype");
            return (Criteria) this;
        }

        public Criteria andChanneltypeLessThanOrEqualTo(Integer value) {
            addCriterion("ChannelType <=", value, "channeltype");
            return (Criteria) this;
        }

        public Criteria andChanneltypeIn(List<Integer> values) {
            addCriterion("ChannelType in", values, "channeltype");
            return (Criteria) this;
        }

        public Criteria andChanneltypeNotIn(List<Integer> values) {
            addCriterion("ChannelType not in", values, "channeltype");
            return (Criteria) this;
        }

        public Criteria andChanneltypeBetween(Integer value1, Integer value2) {
            addCriterion("ChannelType between", value1, value2, "channeltype");
            return (Criteria) this;
        }

        public Criteria andChanneltypeNotBetween(Integer value1, Integer value2) {
            addCriterion("ChannelType not between", value1, value2, "channeltype");
            return (Criteria) this;
        }

        public Criteria andModeltypeIsNull() {
            addCriterion("ModelType is null");
            return (Criteria) this;
        }

        public Criteria andModeltypeIsNotNull() {
            addCriterion("ModelType is not null");
            return (Criteria) this;
        }

        public Criteria andModeltypeEqualTo(Integer value) {
            addCriterion("ModelType =", value, "modeltype");
            return (Criteria) this;
        }

        public Criteria andModeltypeNotEqualTo(Integer value) {
            addCriterion("ModelType <>", value, "modeltype");
            return (Criteria) this;
        }

        public Criteria andModeltypeGreaterThan(Integer value) {
            addCriterion("ModelType >", value, "modeltype");
            return (Criteria) this;
        }

        public Criteria andModeltypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("ModelType >=", value, "modeltype");
            return (Criteria) this;
        }

        public Criteria andModeltypeLessThan(Integer value) {
            addCriterion("ModelType <", value, "modeltype");
            return (Criteria) this;
        }

        public Criteria andModeltypeLessThanOrEqualTo(Integer value) {
            addCriterion("ModelType <=", value, "modeltype");
            return (Criteria) this;
        }

        public Criteria andModeltypeIn(List<Integer> values) {
            addCriterion("ModelType in", values, "modeltype");
            return (Criteria) this;
        }

        public Criteria andModeltypeNotIn(List<Integer> values) {
            addCriterion("ModelType not in", values, "modeltype");
            return (Criteria) this;
        }

        public Criteria andModeltypeBetween(Integer value1, Integer value2) {
            addCriterion("ModelType between", value1, value2, "modeltype");
            return (Criteria) this;
        }

        public Criteria andModeltypeNotBetween(Integer value1, Integer value2) {
            addCriterion("ModelType not between", value1, value2, "modeltype");
            return (Criteria) this;
        }

        public Criteria andOrderusernameIsNull() {
            addCriterion("OrderUserName is null");
            return (Criteria) this;
        }

        public Criteria andOrderusernameIsNotNull() {
            addCriterion("OrderUserName is not null");
            return (Criteria) this;
        }

        public Criteria andOrderusernameEqualTo(String value) {
            addCriterion("OrderUserName =", value, "orderusername");
            return (Criteria) this;
        }

        public Criteria andOrderusernameNotEqualTo(String value) {
            addCriterion("OrderUserName <>", value, "orderusername");
            return (Criteria) this;
        }

        public Criteria andOrderusernameGreaterThan(String value) {
            addCriterion("OrderUserName >", value, "orderusername");
            return (Criteria) this;
        }

        public Criteria andOrderusernameGreaterThanOrEqualTo(String value) {
            addCriterion("OrderUserName >=", value, "orderusername");
            return (Criteria) this;
        }

        public Criteria andOrderusernameLessThan(String value) {
            addCriterion("OrderUserName <", value, "orderusername");
            return (Criteria) this;
        }

        public Criteria andOrderusernameLessThanOrEqualTo(String value) {
            addCriterion("OrderUserName <=", value, "orderusername");
            return (Criteria) this;
        }

        public Criteria andOrderusernameLike(String value) {
            addCriterion("OrderUserName like", value, "orderusername");
            return (Criteria) this;
        }

        public Criteria andOrderusernameNotLike(String value) {
            addCriterion("OrderUserName not like", value, "orderusername");
            return (Criteria) this;
        }

        public Criteria andOrderusernameIn(List<String> values) {
            addCriterion("OrderUserName in", values, "orderusername");
            return (Criteria) this;
        }

        public Criteria andOrderusernameNotIn(List<String> values) {
            addCriterion("OrderUserName not in", values, "orderusername");
            return (Criteria) this;
        }

        public Criteria andOrderusernameBetween(String value1, String value2) {
            addCriterion("OrderUserName between", value1, value2, "orderusername");
            return (Criteria) this;
        }

        public Criteria andOrderusernameNotBetween(String value1, String value2) {
            addCriterion("OrderUserName not between", value1, value2, "orderusername");
            return (Criteria) this;
        }

        public Criteria andOrderuserphoneIsNull() {
            addCriterion("OrderUserPhone is null");
            return (Criteria) this;
        }

        public Criteria andOrderuserphoneIsNotNull() {
            addCriterion("OrderUserPhone is not null");
            return (Criteria) this;
        }

        public Criteria andOrderuserphoneEqualTo(String value) {
            addCriterion("OrderUserPhone =", value, "orderuserphone");
            return (Criteria) this;
        }

        public Criteria andOrderuserphoneNotEqualTo(String value) {
            addCriterion("OrderUserPhone <>", value, "orderuserphone");
            return (Criteria) this;
        }

        public Criteria andOrderuserphoneGreaterThan(String value) {
            addCriterion("OrderUserPhone >", value, "orderuserphone");
            return (Criteria) this;
        }

        public Criteria andOrderuserphoneGreaterThanOrEqualTo(String value) {
            addCriterion("OrderUserPhone >=", value, "orderuserphone");
            return (Criteria) this;
        }

        public Criteria andOrderuserphoneLessThan(String value) {
            addCriterion("OrderUserPhone <", value, "orderuserphone");
            return (Criteria) this;
        }

        public Criteria andOrderuserphoneLessThanOrEqualTo(String value) {
            addCriterion("OrderUserPhone <=", value, "orderuserphone");
            return (Criteria) this;
        }

        public Criteria andOrderuserphoneLike(String value) {
            addCriterion("OrderUserPhone like", value, "orderuserphone");
            return (Criteria) this;
        }

        public Criteria andOrderuserphoneNotLike(String value) {
            addCriterion("OrderUserPhone not like", value, "orderuserphone");
            return (Criteria) this;
        }

        public Criteria andOrderuserphoneIn(List<String> values) {
            addCriterion("OrderUserPhone in", values, "orderuserphone");
            return (Criteria) this;
        }

        public Criteria andOrderuserphoneNotIn(List<String> values) {
            addCriterion("OrderUserPhone not in", values, "orderuserphone");
            return (Criteria) this;
        }

        public Criteria andOrderuserphoneBetween(String value1, String value2) {
            addCriterion("OrderUserPhone between", value1, value2, "orderuserphone");
            return (Criteria) this;
        }

        public Criteria andOrderuserphoneNotBetween(String value1, String value2) {
            addCriterion("OrderUserPhone not between", value1, value2, "orderuserphone");
            return (Criteria) this;
        }

        public Criteria andOrderusermobileIsNull() {
            addCriterion("OrderUserMobile is null");
            return (Criteria) this;
        }

        public Criteria andOrderusermobileIsNotNull() {
            addCriterion("OrderUserMobile is not null");
            return (Criteria) this;
        }

        public Criteria andOrderusermobileEqualTo(String value) {
            addCriterion("OrderUserMobile =", value, "orderusermobile");
            return (Criteria) this;
        }

        public Criteria andOrderusermobileNotEqualTo(String value) {
            addCriterion("OrderUserMobile <>", value, "orderusermobile");
            return (Criteria) this;
        }

        public Criteria andOrderusermobileGreaterThan(String value) {
            addCriterion("OrderUserMobile >", value, "orderusermobile");
            return (Criteria) this;
        }

        public Criteria andOrderusermobileGreaterThanOrEqualTo(String value) {
            addCriterion("OrderUserMobile >=", value, "orderusermobile");
            return (Criteria) this;
        }

        public Criteria andOrderusermobileLessThan(String value) {
            addCriterion("OrderUserMobile <", value, "orderusermobile");
            return (Criteria) this;
        }

        public Criteria andOrderusermobileLessThanOrEqualTo(String value) {
            addCriterion("OrderUserMobile <=", value, "orderusermobile");
            return (Criteria) this;
        }

        public Criteria andOrderusermobileLike(String value) {
            addCriterion("OrderUserMobile like", value, "orderusermobile");
            return (Criteria) this;
        }

        public Criteria andOrderusermobileNotLike(String value) {
            addCriterion("OrderUserMobile not like", value, "orderusermobile");
            return (Criteria) this;
        }

        public Criteria andOrderusermobileIn(List<String> values) {
            addCriterion("OrderUserMobile in", values, "orderusermobile");
            return (Criteria) this;
        }

        public Criteria andOrderusermobileNotIn(List<String> values) {
            addCriterion("OrderUserMobile not in", values, "orderusermobile");
            return (Criteria) this;
        }

        public Criteria andOrderusermobileBetween(String value1, String value2) {
            addCriterion("OrderUserMobile between", value1, value2, "orderusermobile");
            return (Criteria) this;
        }

        public Criteria andOrderusermobileNotBetween(String value1, String value2) {
            addCriterion("OrderUserMobile not between", value1, value2, "orderusermobile");
            return (Criteria) this;
        }

        public Criteria andOrderuseremailIsNull() {
            addCriterion("OrderUserEmail is null");
            return (Criteria) this;
        }

        public Criteria andOrderuseremailIsNotNull() {
            addCriterion("OrderUserEmail is not null");
            return (Criteria) this;
        }

        public Criteria andOrderuseremailEqualTo(String value) {
            addCriterion("OrderUserEmail =", value, "orderuseremail");
            return (Criteria) this;
        }

        public Criteria andOrderuseremailNotEqualTo(String value) {
            addCriterion("OrderUserEmail <>", value, "orderuseremail");
            return (Criteria) this;
        }

        public Criteria andOrderuseremailGreaterThan(String value) {
            addCriterion("OrderUserEmail >", value, "orderuseremail");
            return (Criteria) this;
        }

        public Criteria andOrderuseremailGreaterThanOrEqualTo(String value) {
            addCriterion("OrderUserEmail >=", value, "orderuseremail");
            return (Criteria) this;
        }

        public Criteria andOrderuseremailLessThan(String value) {
            addCriterion("OrderUserEmail <", value, "orderuseremail");
            return (Criteria) this;
        }

        public Criteria andOrderuseremailLessThanOrEqualTo(String value) {
            addCriterion("OrderUserEmail <=", value, "orderuseremail");
            return (Criteria) this;
        }

        public Criteria andOrderuseremailLike(String value) {
            addCriterion("OrderUserEmail like", value, "orderuseremail");
            return (Criteria) this;
        }

        public Criteria andOrderuseremailNotLike(String value) {
            addCriterion("OrderUserEmail not like", value, "orderuseremail");
            return (Criteria) this;
        }

        public Criteria andOrderuseremailIn(List<String> values) {
            addCriterion("OrderUserEmail in", values, "orderuseremail");
            return (Criteria) this;
        }

        public Criteria andOrderuseremailNotIn(List<String> values) {
            addCriterion("OrderUserEmail not in", values, "orderuseremail");
            return (Criteria) this;
        }

        public Criteria andOrderuseremailBetween(String value1, String value2) {
            addCriterion("OrderUserEmail between", value1, value2, "orderuseremail");
            return (Criteria) this;
        }

        public Criteria andOrderuseremailNotBetween(String value1, String value2) {
            addCriterion("OrderUserEmail not between", value1, value2, "orderuseremail");
            return (Criteria) this;
        }

        public Criteria andConsigneeemailIsNull() {
            addCriterion("ConsigneeEmail is null");
            return (Criteria) this;
        }

        public Criteria andConsigneeemailIsNotNull() {
            addCriterion("ConsigneeEmail is not null");
            return (Criteria) this;
        }

        public Criteria andConsigneeemailEqualTo(String value) {
            addCriterion("ConsigneeEmail =", value, "consigneeemail");
            return (Criteria) this;
        }

        public Criteria andConsigneeemailNotEqualTo(String value) {
            addCriterion("ConsigneeEmail <>", value, "consigneeemail");
            return (Criteria) this;
        }

        public Criteria andConsigneeemailGreaterThan(String value) {
            addCriterion("ConsigneeEmail >", value, "consigneeemail");
            return (Criteria) this;
        }

        public Criteria andConsigneeemailGreaterThanOrEqualTo(String value) {
            addCriterion("ConsigneeEmail >=", value, "consigneeemail");
            return (Criteria) this;
        }

        public Criteria andConsigneeemailLessThan(String value) {
            addCriterion("ConsigneeEmail <", value, "consigneeemail");
            return (Criteria) this;
        }

        public Criteria andConsigneeemailLessThanOrEqualTo(String value) {
            addCriterion("ConsigneeEmail <=", value, "consigneeemail");
            return (Criteria) this;
        }

        public Criteria andConsigneeemailLike(String value) {
            addCriterion("ConsigneeEmail like", value, "consigneeemail");
            return (Criteria) this;
        }

        public Criteria andConsigneeemailNotLike(String value) {
            addCriterion("ConsigneeEmail not like", value, "consigneeemail");
            return (Criteria) this;
        }

        public Criteria andConsigneeemailIn(List<String> values) {
            addCriterion("ConsigneeEmail in", values, "consigneeemail");
            return (Criteria) this;
        }

        public Criteria andConsigneeemailNotIn(List<String> values) {
            addCriterion("ConsigneeEmail not in", values, "consigneeemail");
            return (Criteria) this;
        }

        public Criteria andConsigneeemailBetween(String value1, String value2) {
            addCriterion("ConsigneeEmail between", value1, value2, "consigneeemail");
            return (Criteria) this;
        }

        public Criteria andConsigneeemailNotBetween(String value1, String value2) {
            addCriterion("ConsigneeEmail not between", value1, value2, "consigneeemail");
            return (Criteria) this;
        }

        public Criteria andDistributorcodeIsNull() {
            addCriterion("DistributorCode is null");
            return (Criteria) this;
        }

        public Criteria andDistributorcodeIsNotNull() {
            addCriterion("DistributorCode is not null");
            return (Criteria) this;
        }

        public Criteria andDistributorcodeEqualTo(String value) {
            addCriterion("DistributorCode =", value, "distributorcode");
            return (Criteria) this;
        }

        public Criteria andDistributorcodeNotEqualTo(String value) {
            addCriterion("DistributorCode <>", value, "distributorcode");
            return (Criteria) this;
        }

        public Criteria andDistributorcodeGreaterThan(String value) {
            addCriterion("DistributorCode >", value, "distributorcode");
            return (Criteria) this;
        }

        public Criteria andDistributorcodeGreaterThanOrEqualTo(String value) {
            addCriterion("DistributorCode >=", value, "distributorcode");
            return (Criteria) this;
        }

        public Criteria andDistributorcodeLessThan(String value) {
            addCriterion("DistributorCode <", value, "distributorcode");
            return (Criteria) this;
        }

        public Criteria andDistributorcodeLessThanOrEqualTo(String value) {
            addCriterion("DistributorCode <=", value, "distributorcode");
            return (Criteria) this;
        }

        public Criteria andDistributorcodeLike(String value) {
            addCriterion("DistributorCode like", value, "distributorcode");
            return (Criteria) this;
        }

        public Criteria andDistributorcodeNotLike(String value) {
            addCriterion("DistributorCode not like", value, "distributorcode");
            return (Criteria) this;
        }

        public Criteria andDistributorcodeIn(List<String> values) {
            addCriterion("DistributorCode in", values, "distributorcode");
            return (Criteria) this;
        }

        public Criteria andDistributorcodeNotIn(List<String> values) {
            addCriterion("DistributorCode not in", values, "distributorcode");
            return (Criteria) this;
        }

        public Criteria andDistributorcodeBetween(String value1, String value2) {
            addCriterion("DistributorCode between", value1, value2, "distributorcode");
            return (Criteria) this;
        }

        public Criteria andDistributorcodeNotBetween(String value1, String value2) {
            addCriterion("DistributorCode not between", value1, value2, "distributorcode");
            return (Criteria) this;
        }

        public Criteria andDistributornameIsNull() {
            addCriterion("DistributorName is null");
            return (Criteria) this;
        }

        public Criteria andDistributornameIsNotNull() {
            addCriterion("DistributorName is not null");
            return (Criteria) this;
        }

        public Criteria andDistributornameEqualTo(String value) {
            addCriterion("DistributorName =", value, "distributorname");
            return (Criteria) this;
        }

        public Criteria andDistributornameNotEqualTo(String value) {
            addCriterion("DistributorName <>", value, "distributorname");
            return (Criteria) this;
        }

        public Criteria andDistributornameGreaterThan(String value) {
            addCriterion("DistributorName >", value, "distributorname");
            return (Criteria) this;
        }

        public Criteria andDistributornameGreaterThanOrEqualTo(String value) {
            addCriterion("DistributorName >=", value, "distributorname");
            return (Criteria) this;
        }

        public Criteria andDistributornameLessThan(String value) {
            addCriterion("DistributorName <", value, "distributorname");
            return (Criteria) this;
        }

        public Criteria andDistributornameLessThanOrEqualTo(String value) {
            addCriterion("DistributorName <=", value, "distributorname");
            return (Criteria) this;
        }

        public Criteria andDistributornameLike(String value) {
            addCriterion("DistributorName like", value, "distributorname");
            return (Criteria) this;
        }

        public Criteria andDistributornameNotLike(String value) {
            addCriterion("DistributorName not like", value, "distributorname");
            return (Criteria) this;
        }

        public Criteria andDistributornameIn(List<String> values) {
            addCriterion("DistributorName in", values, "distributorname");
            return (Criteria) this;
        }

        public Criteria andDistributornameNotIn(List<String> values) {
            addCriterion("DistributorName not in", values, "distributorname");
            return (Criteria) this;
        }

        public Criteria andDistributornameBetween(String value1, String value2) {
            addCriterion("DistributorName between", value1, value2, "distributorname");
            return (Criteria) this;
        }

        public Criteria andDistributornameNotBetween(String value1, String value2) {
            addCriterion("DistributorName not between", value1, value2, "distributorname");
            return (Criteria) this;
        }

        public Criteria andSourcetypeIsNull() {
            addCriterion("SourceType is null");
            return (Criteria) this;
        }

        public Criteria andSourcetypeIsNotNull() {
            addCriterion("SourceType is not null");
            return (Criteria) this;
        }

        public Criteria andSourcetypeEqualTo(Integer value) {
            addCriterion("SourceType =", value, "sourcetype");
            return (Criteria) this;
        }

        public Criteria andSourcetypeNotEqualTo(Integer value) {
            addCriterion("SourceType <>", value, "sourcetype");
            return (Criteria) this;
        }

        public Criteria andSourcetypeGreaterThan(Integer value) {
            addCriterion("SourceType >", value, "sourcetype");
            return (Criteria) this;
        }

        public Criteria andSourcetypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("SourceType >=", value, "sourcetype");
            return (Criteria) this;
        }

        public Criteria andSourcetypeLessThan(Integer value) {
            addCriterion("SourceType <", value, "sourcetype");
            return (Criteria) this;
        }

        public Criteria andSourcetypeLessThanOrEqualTo(Integer value) {
            addCriterion("SourceType <=", value, "sourcetype");
            return (Criteria) this;
        }

        public Criteria andSourcetypeIn(List<Integer> values) {
            addCriterion("SourceType in", values, "sourcetype");
            return (Criteria) this;
        }

        public Criteria andSourcetypeNotIn(List<Integer> values) {
            addCriterion("SourceType not in", values, "sourcetype");
            return (Criteria) this;
        }

        public Criteria andSourcetypeBetween(Integer value1, Integer value2) {
            addCriterion("SourceType between", value1, value2, "sourcetype");
            return (Criteria) this;
        }

        public Criteria andSourcetypeNotBetween(Integer value1, Integer value2) {
            addCriterion("SourceType not between", value1, value2, "sourcetype");
            return (Criteria) this;
        }

        public Criteria andOrdersourceIsNull() {
            addCriterion("OrderSource is null");
            return (Criteria) this;
        }

        public Criteria andOrdersourceIsNotNull() {
            addCriterion("OrderSource is not null");
            return (Criteria) this;
        }

        public Criteria andOrdersourceEqualTo(Integer value) {
            addCriterion("OrderSource =", value, "ordersource");
            return (Criteria) this;
        }

        public Criteria andOrdersourceNotEqualTo(Integer value) {
            addCriterion("OrderSource <>", value, "ordersource");
            return (Criteria) this;
        }

        public Criteria andOrdersourceGreaterThan(Integer value) {
            addCriterion("OrderSource >", value, "ordersource");
            return (Criteria) this;
        }

        public Criteria andOrdersourceGreaterThanOrEqualTo(Integer value) {
            addCriterion("OrderSource >=", value, "ordersource");
            return (Criteria) this;
        }

        public Criteria andOrdersourceLessThan(Integer value) {
            addCriterion("OrderSource <", value, "ordersource");
            return (Criteria) this;
        }

        public Criteria andOrdersourceLessThanOrEqualTo(Integer value) {
            addCriterion("OrderSource <=", value, "ordersource");
            return (Criteria) this;
        }

        public Criteria andOrdersourceIn(List<Integer> values) {
            addCriterion("OrderSource in", values, "ordersource");
            return (Criteria) this;
        }

        public Criteria andOrdersourceNotIn(List<Integer> values) {
            addCriterion("OrderSource not in", values, "ordersource");
            return (Criteria) this;
        }

        public Criteria andOrdersourceBetween(Integer value1, Integer value2) {
            addCriterion("OrderSource between", value1, value2, "ordersource");
            return (Criteria) this;
        }

        public Criteria andOrdersourceNotBetween(Integer value1, Integer value2) {
            addCriterion("OrderSource not between", value1, value2, "ordersource");
            return (Criteria) this;
        }

        public Criteria andDeliverymobileIsNull() {
            addCriterion("DeliveryMobile is null");
            return (Criteria) this;
        }

        public Criteria andDeliverymobileIsNotNull() {
            addCriterion("DeliveryMobile is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverymobileEqualTo(String value) {
            addCriterion("DeliveryMobile =", value, "deliverymobile");
            return (Criteria) this;
        }

        public Criteria andDeliverymobileNotEqualTo(String value) {
            addCriterion("DeliveryMobile <>", value, "deliverymobile");
            return (Criteria) this;
        }

        public Criteria andDeliverymobileGreaterThan(String value) {
            addCriterion("DeliveryMobile >", value, "deliverymobile");
            return (Criteria) this;
        }

        public Criteria andDeliverymobileGreaterThanOrEqualTo(String value) {
            addCriterion("DeliveryMobile >=", value, "deliverymobile");
            return (Criteria) this;
        }

        public Criteria andDeliverymobileLessThan(String value) {
            addCriterion("DeliveryMobile <", value, "deliverymobile");
            return (Criteria) this;
        }

        public Criteria andDeliverymobileLessThanOrEqualTo(String value) {
            addCriterion("DeliveryMobile <=", value, "deliverymobile");
            return (Criteria) this;
        }

        public Criteria andDeliverymobileLike(String value) {
            addCriterion("DeliveryMobile like", value, "deliverymobile");
            return (Criteria) this;
        }

        public Criteria andDeliverymobileNotLike(String value) {
            addCriterion("DeliveryMobile not like", value, "deliverymobile");
            return (Criteria) this;
        }

        public Criteria andDeliverymobileIn(List<String> values) {
            addCriterion("DeliveryMobile in", values, "deliverymobile");
            return (Criteria) this;
        }

        public Criteria andDeliverymobileNotIn(List<String> values) {
            addCriterion("DeliveryMobile not in", values, "deliverymobile");
            return (Criteria) this;
        }

        public Criteria andDeliverymobileBetween(String value1, String value2) {
            addCriterion("DeliveryMobile between", value1, value2, "deliverymobile");
            return (Criteria) this;
        }

        public Criteria andDeliverymobileNotBetween(String value1, String value2) {
            addCriterion("DeliveryMobile not between", value1, value2, "deliverymobile");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousecodeIsNull() {
            addCriterion("FrontWarehouseCode is null");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousecodeIsNotNull() {
            addCriterion("FrontWarehouseCode is not null");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousecodeEqualTo(String value) {
            addCriterion("FrontWarehouseCode =", value, "frontwarehousecode");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousecodeNotEqualTo(String value) {
            addCriterion("FrontWarehouseCode <>", value, "frontwarehousecode");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousecodeGreaterThan(String value) {
            addCriterion("FrontWarehouseCode >", value, "frontwarehousecode");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousecodeGreaterThanOrEqualTo(String value) {
            addCriterion("FrontWarehouseCode >=", value, "frontwarehousecode");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousecodeLessThan(String value) {
            addCriterion("FrontWarehouseCode <", value, "frontwarehousecode");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousecodeLessThanOrEqualTo(String value) {
            addCriterion("FrontWarehouseCode <=", value, "frontwarehousecode");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousecodeLike(String value) {
            addCriterion("FrontWarehouseCode like", value, "frontwarehousecode");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousecodeNotLike(String value) {
            addCriterion("FrontWarehouseCode not like", value, "frontwarehousecode");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousecodeIn(List<String> values) {
            addCriterion("FrontWarehouseCode in", values, "frontwarehousecode");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousecodeNotIn(List<String> values) {
            addCriterion("FrontWarehouseCode not in", values, "frontwarehousecode");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousecodeBetween(String value1, String value2) {
            addCriterion("FrontWarehouseCode between", value1, value2, "frontwarehousecode");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousecodeNotBetween(String value1, String value2) {
            addCriterion("FrontWarehouseCode not between", value1, value2, "frontwarehousecode");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousenameIsNull() {
            addCriterion("FrontWarehouseName is null");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousenameIsNotNull() {
            addCriterion("FrontWarehouseName is not null");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousenameEqualTo(String value) {
            addCriterion("FrontWarehouseName =", value, "frontwarehousename");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousenameNotEqualTo(String value) {
            addCriterion("FrontWarehouseName <>", value, "frontwarehousename");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousenameGreaterThan(String value) {
            addCriterion("FrontWarehouseName >", value, "frontwarehousename");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousenameGreaterThanOrEqualTo(String value) {
            addCriterion("FrontWarehouseName >=", value, "frontwarehousename");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousenameLessThan(String value) {
            addCriterion("FrontWarehouseName <", value, "frontwarehousename");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousenameLessThanOrEqualTo(String value) {
            addCriterion("FrontWarehouseName <=", value, "frontwarehousename");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousenameLike(String value) {
            addCriterion("FrontWarehouseName like", value, "frontwarehousename");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousenameNotLike(String value) {
            addCriterion("FrontWarehouseName not like", value, "frontwarehousename");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousenameIn(List<String> values) {
            addCriterion("FrontWarehouseName in", values, "frontwarehousename");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousenameNotIn(List<String> values) {
            addCriterion("FrontWarehouseName not in", values, "frontwarehousename");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousenameBetween(String value1, String value2) {
            addCriterion("FrontWarehouseName between", value1, value2, "frontwarehousename");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousenameNotBetween(String value1, String value2) {
            addCriterion("FrontWarehouseName not between", value1, value2, "frontwarehousename");
            return (Criteria) this;
        }

        public Criteria andDeliverytimeefficiencyIsNull() {
            addCriterion("DeliveryTimeEfficiency is null");
            return (Criteria) this;
        }

        public Criteria andDeliverytimeefficiencyIsNotNull() {
            addCriterion("DeliveryTimeEfficiency is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverytimeefficiencyEqualTo(Double value) {
            addCriterion("DeliveryTimeEfficiency =", value, "deliverytimeefficiency");
            return (Criteria) this;
        }

        public Criteria andDeliverytimeefficiencyNotEqualTo(Double value) {
            addCriterion("DeliveryTimeEfficiency <>", value, "deliverytimeefficiency");
            return (Criteria) this;
        }

        public Criteria andDeliverytimeefficiencyGreaterThan(Double value) {
            addCriterion("DeliveryTimeEfficiency >", value, "deliverytimeefficiency");
            return (Criteria) this;
        }

        public Criteria andDeliverytimeefficiencyGreaterThanOrEqualTo(Double value) {
            addCriterion("DeliveryTimeEfficiency >=", value, "deliverytimeefficiency");
            return (Criteria) this;
        }

        public Criteria andDeliverytimeefficiencyLessThan(Double value) {
            addCriterion("DeliveryTimeEfficiency <", value, "deliverytimeefficiency");
            return (Criteria) this;
        }

        public Criteria andDeliverytimeefficiencyLessThanOrEqualTo(Double value) {
            addCriterion("DeliveryTimeEfficiency <=", value, "deliverytimeefficiency");
            return (Criteria) this;
        }

        public Criteria andDeliverytimeefficiencyIn(List<Double> values) {
            addCriterion("DeliveryTimeEfficiency in", values, "deliverytimeefficiency");
            return (Criteria) this;
        }

        public Criteria andDeliverytimeefficiencyNotIn(List<Double> values) {
            addCriterion("DeliveryTimeEfficiency not in", values, "deliverytimeefficiency");
            return (Criteria) this;
        }

        public Criteria andDeliverytimeefficiencyBetween(Double value1, Double value2) {
            addCriterion("DeliveryTimeEfficiency between", value1, value2, "deliverytimeefficiency");
            return (Criteria) this;
        }

        public Criteria andDeliverytimeefficiencyNotBetween(Double value1, Double value2) {
            addCriterion("DeliveryTimeEfficiency not between", value1, value2, "deliverytimeefficiency");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIsNull() {
            addCriterion("OrderTime is null");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIsNotNull() {
            addCriterion("OrderTime is not null");
            return (Criteria) this;
        }

        public Criteria andOrdertimeEqualTo(Date value) {
            addCriterion("OrderTime =", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotEqualTo(Date value) {
            addCriterion("OrderTime <>", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeGreaterThan(Date value) {
            addCriterion("OrderTime >", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeGreaterThanOrEqualTo(Date value) {
            addCriterion("OrderTime >=", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeLessThan(Date value) {
            addCriterion("OrderTime <", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeLessThanOrEqualTo(Date value) {
            addCriterion("OrderTime <=", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIn(List<Date> values) {
            addCriterion("OrderTime in", values, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotIn(List<Date> values) {
            addCriterion("OrderTime not in", values, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeBetween(Date value1, Date value2) {
            addCriterion("OrderTime between", value1, value2, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotBetween(Date value1, Date value2) {
            addCriterion("OrderTime not between", value1, value2, "ordertime");
            return (Criteria) this;
        }

        public Criteria andSenddownresultIsNull() {
            addCriterion("SendDownResult is null");
            return (Criteria) this;
        }

        public Criteria andSenddownresultIsNotNull() {
            addCriterion("SendDownResult is not null");
            return (Criteria) this;
        }

        public Criteria andSenddownresultEqualTo(String value) {
            addCriterion("SendDownResult =", value, "senddownresult");
            return (Criteria) this;
        }

        public Criteria andSenddownresultNotEqualTo(String value) {
            addCriterion("SendDownResult <>", value, "senddownresult");
            return (Criteria) this;
        }

        public Criteria andSenddownresultGreaterThan(String value) {
            addCriterion("SendDownResult >", value, "senddownresult");
            return (Criteria) this;
        }

        public Criteria andSenddownresultGreaterThanOrEqualTo(String value) {
            addCriterion("SendDownResult >=", value, "senddownresult");
            return (Criteria) this;
        }

        public Criteria andSenddownresultLessThan(String value) {
            addCriterion("SendDownResult <", value, "senddownresult");
            return (Criteria) this;
        }

        public Criteria andSenddownresultLessThanOrEqualTo(String value) {
            addCriterion("SendDownResult <=", value, "senddownresult");
            return (Criteria) this;
        }

        public Criteria andSenddownresultLike(String value) {
            addCriterion("SendDownResult like", value, "senddownresult");
            return (Criteria) this;
        }

        public Criteria andSenddownresultNotLike(String value) {
            addCriterion("SendDownResult not like", value, "senddownresult");
            return (Criteria) this;
        }

        public Criteria andSenddownresultIn(List<String> values) {
            addCriterion("SendDownResult in", values, "senddownresult");
            return (Criteria) this;
        }

        public Criteria andSenddownresultNotIn(List<String> values) {
            addCriterion("SendDownResult not in", values, "senddownresult");
            return (Criteria) this;
        }

        public Criteria andSenddownresultBetween(String value1, String value2) {
            addCriterion("SendDownResult between", value1, value2, "senddownresult");
            return (Criteria) this;
        }

        public Criteria andSenddownresultNotBetween(String value1, String value2) {
            addCriterion("SendDownResult not between", value1, value2, "senddownresult");
            return (Criteria) this;
        }

        public Criteria andSenddownstatusIsNull() {
            addCriterion("SendDownStatus is null");
            return (Criteria) this;
        }

        public Criteria andSenddownstatusIsNotNull() {
            addCriterion("SendDownStatus is not null");
            return (Criteria) this;
        }

        public Criteria andSenddownstatusEqualTo(Integer value) {
            addCriterion("SendDownStatus =", value, "senddownstatus");
            return (Criteria) this;
        }

        public Criteria andSenddownstatusNotEqualTo(Integer value) {
            addCriterion("SendDownStatus <>", value, "senddownstatus");
            return (Criteria) this;
        }

        public Criteria andSenddownstatusGreaterThan(Integer value) {
            addCriterion("SendDownStatus >", value, "senddownstatus");
            return (Criteria) this;
        }

        public Criteria andSenddownstatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("SendDownStatus >=", value, "senddownstatus");
            return (Criteria) this;
        }

        public Criteria andSenddownstatusLessThan(Integer value) {
            addCriterion("SendDownStatus <", value, "senddownstatus");
            return (Criteria) this;
        }

        public Criteria andSenddownstatusLessThanOrEqualTo(Integer value) {
            addCriterion("SendDownStatus <=", value, "senddownstatus");
            return (Criteria) this;
        }

        public Criteria andSenddownstatusIn(List<Integer> values) {
            addCriterion("SendDownStatus in", values, "senddownstatus");
            return (Criteria) this;
        }

        public Criteria andSenddownstatusNotIn(List<Integer> values) {
            addCriterion("SendDownStatus not in", values, "senddownstatus");
            return (Criteria) this;
        }

        public Criteria andSenddownstatusBetween(Integer value1, Integer value2) {
            addCriterion("SendDownStatus between", value1, value2, "senddownstatus");
            return (Criteria) this;
        }

        public Criteria andSenddownstatusNotBetween(Integer value1, Integer value2) {
            addCriterion("SendDownStatus not between", value1, value2, "senddownstatus");
            return (Criteria) this;
        }

        public Criteria andReceiptidIsNull() {
            addCriterion("ReceiptId is null");
            return (Criteria) this;
        }

        public Criteria andReceiptidIsNotNull() {
            addCriterion("ReceiptId is not null");
            return (Criteria) this;
        }

        public Criteria andReceiptidEqualTo(String value) {
            addCriterion("ReceiptId =", value, "receiptid");
            return (Criteria) this;
        }

        public Criteria andReceiptidNotEqualTo(String value) {
            addCriterion("ReceiptId <>", value, "receiptid");
            return (Criteria) this;
        }

        public Criteria andReceiptidGreaterThan(String value) {
            addCriterion("ReceiptId >", value, "receiptid");
            return (Criteria) this;
        }

        public Criteria andReceiptidGreaterThanOrEqualTo(String value) {
            addCriterion("ReceiptId >=", value, "receiptid");
            return (Criteria) this;
        }

        public Criteria andReceiptidLessThan(String value) {
            addCriterion("ReceiptId <", value, "receiptid");
            return (Criteria) this;
        }

        public Criteria andReceiptidLessThanOrEqualTo(String value) {
            addCriterion("ReceiptId <=", value, "receiptid");
            return (Criteria) this;
        }

        public Criteria andReceiptidLike(String value) {
            addCriterion("ReceiptId like", value, "receiptid");
            return (Criteria) this;
        }

        public Criteria andReceiptidNotLike(String value) {
            addCriterion("ReceiptId not like", value, "receiptid");
            return (Criteria) this;
        }

        public Criteria andReceiptidIn(List<String> values) {
            addCriterion("ReceiptId in", values, "receiptid");
            return (Criteria) this;
        }

        public Criteria andReceiptidNotIn(List<String> values) {
            addCriterion("ReceiptId not in", values, "receiptid");
            return (Criteria) this;
        }

        public Criteria andReceiptidBetween(String value1, String value2) {
            addCriterion("ReceiptId between", value1, value2, "receiptid");
            return (Criteria) this;
        }

        public Criteria andReceiptidNotBetween(String value1, String value2) {
            addCriterion("ReceiptId not between", value1, value2, "receiptid");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousetelIsNull() {
            addCriterion("FrontWarehouseTel is null");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousetelIsNotNull() {
            addCriterion("FrontWarehouseTel is not null");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousetelEqualTo(String value) {
            addCriterion("FrontWarehouseTel =", value, "frontwarehousetel");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousetelNotEqualTo(String value) {
            addCriterion("FrontWarehouseTel <>", value, "frontwarehousetel");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousetelGreaterThan(String value) {
            addCriterion("FrontWarehouseTel >", value, "frontwarehousetel");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousetelGreaterThanOrEqualTo(String value) {
            addCriterion("FrontWarehouseTel >=", value, "frontwarehousetel");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousetelLessThan(String value) {
            addCriterion("FrontWarehouseTel <", value, "frontwarehousetel");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousetelLessThanOrEqualTo(String value) {
            addCriterion("FrontWarehouseTel <=", value, "frontwarehousetel");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousetelLike(String value) {
            addCriterion("FrontWarehouseTel like", value, "frontwarehousetel");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousetelNotLike(String value) {
            addCriterion("FrontWarehouseTel not like", value, "frontwarehousetel");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousetelIn(List<String> values) {
            addCriterion("FrontWarehouseTel in", values, "frontwarehousetel");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousetelNotIn(List<String> values) {
            addCriterion("FrontWarehouseTel not in", values, "frontwarehousetel");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousetelBetween(String value1, String value2) {
            addCriterion("FrontWarehouseTel between", value1, value2, "frontwarehousetel");
            return (Criteria) this;
        }

        public Criteria andFrontwarehousetelNotBetween(String value1, String value2) {
            addCriterion("FrontWarehouseTel not between", value1, value2, "frontwarehousetel");
            return (Criteria) this;
        }

        public Criteria andFrontwarehouseaddressIsNull() {
            addCriterion("FrontWarehouseAddress is null");
            return (Criteria) this;
        }

        public Criteria andFrontwarehouseaddressIsNotNull() {
            addCriterion("FrontWarehouseAddress is not null");
            return (Criteria) this;
        }

        public Criteria andFrontwarehouseaddressEqualTo(String value) {
            addCriterion("FrontWarehouseAddress =", value, "frontwarehouseaddress");
            return (Criteria) this;
        }

        public Criteria andFrontwarehouseaddressNotEqualTo(String value) {
            addCriterion("FrontWarehouseAddress <>", value, "frontwarehouseaddress");
            return (Criteria) this;
        }

        public Criteria andFrontwarehouseaddressGreaterThan(String value) {
            addCriterion("FrontWarehouseAddress >", value, "frontwarehouseaddress");
            return (Criteria) this;
        }

        public Criteria andFrontwarehouseaddressGreaterThanOrEqualTo(String value) {
            addCriterion("FrontWarehouseAddress >=", value, "frontwarehouseaddress");
            return (Criteria) this;
        }

        public Criteria andFrontwarehouseaddressLessThan(String value) {
            addCriterion("FrontWarehouseAddress <", value, "frontwarehouseaddress");
            return (Criteria) this;
        }

        public Criteria andFrontwarehouseaddressLessThanOrEqualTo(String value) {
            addCriterion("FrontWarehouseAddress <=", value, "frontwarehouseaddress");
            return (Criteria) this;
        }

        public Criteria andFrontwarehouseaddressLike(String value) {
            addCriterion("FrontWarehouseAddress like", value, "frontwarehouseaddress");
            return (Criteria) this;
        }

        public Criteria andFrontwarehouseaddressNotLike(String value) {
            addCriterion("FrontWarehouseAddress not like", value, "frontwarehouseaddress");
            return (Criteria) this;
        }

        public Criteria andFrontwarehouseaddressIn(List<String> values) {
            addCriterion("FrontWarehouseAddress in", values, "frontwarehouseaddress");
            return (Criteria) this;
        }

        public Criteria andFrontwarehouseaddressNotIn(List<String> values) {
            addCriterion("FrontWarehouseAddress not in", values, "frontwarehouseaddress");
            return (Criteria) this;
        }

        public Criteria andFrontwarehouseaddressBetween(String value1, String value2) {
            addCriterion("FrontWarehouseAddress between", value1, value2, "frontwarehouseaddress");
            return (Criteria) this;
        }

        public Criteria andFrontwarehouseaddressNotBetween(String value1, String value2) {
            addCriterion("FrontWarehouseAddress not between", value1, value2, "frontwarehouseaddress");
            return (Criteria) this;
        }

        public Criteria andThreelogisticscodeIsNull() {
            addCriterion("ThreeLogisticsCode is null");
            return (Criteria) this;
        }

        public Criteria andThreelogisticscodeIsNotNull() {
            addCriterion("ThreeLogisticsCode is not null");
            return (Criteria) this;
        }

        public Criteria andThreelogisticscodeEqualTo(String value) {
            addCriterion("ThreeLogisticsCode =", value, "threelogisticscode");
            return (Criteria) this;
        }

        public Criteria andThreelogisticscodeNotEqualTo(String value) {
            addCriterion("ThreeLogisticsCode <>", value, "threelogisticscode");
            return (Criteria) this;
        }

        public Criteria andThreelogisticscodeGreaterThan(String value) {
            addCriterion("ThreeLogisticsCode >", value, "threelogisticscode");
            return (Criteria) this;
        }

        public Criteria andThreelogisticscodeGreaterThanOrEqualTo(String value) {
            addCriterion("ThreeLogisticsCode >=", value, "threelogisticscode");
            return (Criteria) this;
        }

        public Criteria andThreelogisticscodeLessThan(String value) {
            addCriterion("ThreeLogisticsCode <", value, "threelogisticscode");
            return (Criteria) this;
        }

        public Criteria andThreelogisticscodeLessThanOrEqualTo(String value) {
            addCriterion("ThreeLogisticsCode <=", value, "threelogisticscode");
            return (Criteria) this;
        }

        public Criteria andThreelogisticscodeLike(String value) {
            addCriterion("ThreeLogisticsCode like", value, "threelogisticscode");
            return (Criteria) this;
        }

        public Criteria andThreelogisticscodeNotLike(String value) {
            addCriterion("ThreeLogisticsCode not like", value, "threelogisticscode");
            return (Criteria) this;
        }

        public Criteria andThreelogisticscodeIn(List<String> values) {
            addCriterion("ThreeLogisticsCode in", values, "threelogisticscode");
            return (Criteria) this;
        }

        public Criteria andThreelogisticscodeNotIn(List<String> values) {
            addCriterion("ThreeLogisticsCode not in", values, "threelogisticscode");
            return (Criteria) this;
        }

        public Criteria andThreelogisticscodeBetween(String value1, String value2) {
            addCriterion("ThreeLogisticsCode between", value1, value2, "threelogisticscode");
            return (Criteria) this;
        }

        public Criteria andThreelogisticscodeNotBetween(String value1, String value2) {
            addCriterion("ThreeLogisticsCode not between", value1, value2, "threelogisticscode");
            return (Criteria) this;
        }

        public Criteria andReceiptcodeIsNull() {
            addCriterion("ReceiptCode is null");
            return (Criteria) this;
        }

        public Criteria andReceiptcodeIsNotNull() {
            addCriterion("ReceiptCode is not null");
            return (Criteria) this;
        }

        public Criteria andReceiptcodeEqualTo(String value) {
            addCriterion("ReceiptCode =", value, "receiptcode");
            return (Criteria) this;
        }

        public Criteria andReceiptcodeNotEqualTo(String value) {
            addCriterion("ReceiptCode <>", value, "receiptcode");
            return (Criteria) this;
        }

        public Criteria andReceiptcodeGreaterThan(String value) {
            addCriterion("ReceiptCode >", value, "receiptcode");
            return (Criteria) this;
        }

        public Criteria andReceiptcodeGreaterThanOrEqualTo(String value) {
            addCriterion("ReceiptCode >=", value, "receiptcode");
            return (Criteria) this;
        }

        public Criteria andReceiptcodeLessThan(String value) {
            addCriterion("ReceiptCode <", value, "receiptcode");
            return (Criteria) this;
        }

        public Criteria andReceiptcodeLessThanOrEqualTo(String value) {
            addCriterion("ReceiptCode <=", value, "receiptcode");
            return (Criteria) this;
        }

        public Criteria andReceiptcodeLike(String value) {
            addCriterion("ReceiptCode like", value, "receiptcode");
            return (Criteria) this;
        }

        public Criteria andReceiptcodeNotLike(String value) {
            addCriterion("ReceiptCode not like", value, "receiptcode");
            return (Criteria) this;
        }

        public Criteria andReceiptcodeIn(List<String> values) {
            addCriterion("ReceiptCode in", values, "receiptcode");
            return (Criteria) this;
        }

        public Criteria andReceiptcodeNotIn(List<String> values) {
            addCriterion("ReceiptCode not in", values, "receiptcode");
            return (Criteria) this;
        }

        public Criteria andReceiptcodeBetween(String value1, String value2) {
            addCriterion("ReceiptCode between", value1, value2, "receiptcode");
            return (Criteria) this;
        }

        public Criteria andReceiptcodeNotBetween(String value1, String value2) {
            addCriterion("ReceiptCode not between", value1, value2, "receiptcode");
            return (Criteria) this;
        }

        public Criteria andPushcountIsNull() {
            addCriterion("PushCount is null");
            return (Criteria) this;
        }

        public Criteria andPushcountIsNotNull() {
            addCriterion("PushCount is not null");
            return (Criteria) this;
        }

        public Criteria andPushcountEqualTo(Integer value) {
            addCriterion("PushCount =", value, "pushcount");
            return (Criteria) this;
        }

        public Criteria andPushcountNotEqualTo(Integer value) {
            addCriterion("PushCount <>", value, "pushcount");
            return (Criteria) this;
        }

        public Criteria andPushcountGreaterThan(Integer value) {
            addCriterion("PushCount >", value, "pushcount");
            return (Criteria) this;
        }

        public Criteria andPushcountGreaterThanOrEqualTo(Integer value) {
            addCriterion("PushCount >=", value, "pushcount");
            return (Criteria) this;
        }

        public Criteria andPushcountLessThan(Integer value) {
            addCriterion("PushCount <", value, "pushcount");
            return (Criteria) this;
        }

        public Criteria andPushcountLessThanOrEqualTo(Integer value) {
            addCriterion("PushCount <=", value, "pushcount");
            return (Criteria) this;
        }

        public Criteria andPushcountIn(List<Integer> values) {
            addCriterion("PushCount in", values, "pushcount");
            return (Criteria) this;
        }

        public Criteria andPushcountNotIn(List<Integer> values) {
            addCriterion("PushCount not in", values, "pushcount");
            return (Criteria) this;
        }

        public Criteria andPushcountBetween(Integer value1, Integer value2) {
            addCriterion("PushCount between", value1, value2, "pushcount");
            return (Criteria) this;
        }

        public Criteria andPushcountNotBetween(Integer value1, Integer value2) {
            addCriterion("PushCount not between", value1, value2, "pushcount");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}